Is there an object or DEFINE or variable that represents the last possible cell in a spreadsheet?
We all know that in Excel 2000, the last cell is IV65536, however, that value (IMHO) should be registered as a constant with the Excel Framework.
I'm looking for something like
or even a value that would go in the SpecialCells function
ActiveSheet.Cells.SpecialCells( ... ).Activate