Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4v behaving differently in Excel2007...
I have a 10+ year old add-in (still using Excel4v) that is fairly
complex. Everything seems to work fine in Excel2007 except for a piece of logic that asks for the last cell in a sheet - Excel4v(xlcSelectLastCell, &xRes, 0); Excel4v(xlFree, 0, 1, xRes); Excel4v(xlfActiveCell &xRes. 0); returned xRes is of type error where in previous versions of Excel it was a range note that the error is returned only when this logic is executing after using xlcSelect (anchor column) then xlcInsert to insert a new column. If I haven't inserted a new column then the xlfActiveCell in the logic above does give me a valid range. any ideas why my insert is messing with my last cell? Thanks! -- Danielle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function behaving differently in different spreadsheets | Excel Worksheet Functions | |||
Workbook_BeforeSave not behaving as expected | Excel Programming | |||
Cursor not behaving | Excel Discussion (Misc queries) | |||
SUM() function not behaving | Excel Programming |