Excel Enum Constants 1

[RonRepp]

Hi all:

I'm looking for the .Net equivalants of the Excel Enum Constants.

For example:

XL.Selection.PasteSpecial(Paste:=<b>Excel.XlFindLookIn.xlValues</b>, Operation:=Excel.XlPasteSpecialOperation.xlPasteSpecialOperationMultiply, SkipBlanks _
:=False, Transpose:=False)

Where Excel.XlFindLookIn.xlValues is a constant.

I need the constant for xlSum to do subtotals. Does anyone know of a list of these constants?

Thanks,

Ron


Ron Repp

 

[chrissie1]

There is an excell forum where you will have a better chance to getting an answer.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[RonRepp]

Chrissie:

Where is the Excel Forum? I see Office and VBA, but not Excel. I didn't want to post in either of these because they wouldn't know of the Enums in .Net.

Could you supply a link to the Excel forum, please?

Anyway, I found the answer to my question.

Excel.XlConsolidationFunction.xlSum

Thanks,

Ron

Ron Repp

 

[chrissie1]

yes they would know about them because they aren't .net enums they are in the excel namespace so they are used by the vba people and they are a lot smarter then they look.

you are using the very same namespace that vba does and are using functions that are exactly the same in excell.

So the macrorecorder is your best friend, trust me.

It's us .net guys that don't know the excell enums.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]