Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm writing a method in XLL add-in for excel 2007 using the ComInterop to call Range.SpecialCells using iDispatch.Invoke. but how I can pack the XlCellType as Variant? I've tried to provide the int value of the enum but it didn't work: .... VariantInit(&lCellType); lCellType.vt = VT_INT; lCellType.intVal = -4123; hr = AutoWrap(DISPATCH_METHOD,&lResult, pCellRef/*pionter to Range*/, L"SpecialCells", &lCellType); Any idea? Regards, Raja |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SpecialCells method of Range class failed | Excel Programming | |||
Invert a range? - I wish SpecialCells(xlCellTypeHIDDEN) exist ... | Excel Programming | |||
specialcells(xlLastCell) and method global range error | Excel Programming | |||
Invoking Excel via Getobject(From Access) to invoke Excel Macro | Excel Programming | |||
different IDispatch in event handler | Excel Programming |