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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4v behaving differently in Excel2007...
I know nothing about developing XLLs but I think there were changes in the
SDK for Excel 2007 due to the increase in rows to 1,048,576 and columns to 65,536. You might install the SDK and see if it provides any clues: http://www.microsoft.com/downloads/d...displaylang=en -- Jim "dmsc33" wrote in message ... |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 |
Reply |
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 |