Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
using the code ActiveSheet.Cells.SpecialCells(xlLastCell) normally works
fine. But, sometimes after working on a sheet for a while, the code returns the address to cell IV65536 - the last cell in the sheet. I have tried Clear = All from the unused columns and rows, deleting the unused columns and rows, but once the sheet thinks IV65536 is the last cell, it is stuck. how can I clear up the sheet, so it correctly calculates the last cell? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SpecialCells(xlLastCell) | Excel Programming | |||
How select/define cells with FIND method (maybe together with SpecialCells) | Excel Programming | |||
xlLastCell question | Excel Programming | |||
.SpecialCells(xlLastCell).Select | Excel Programming | |||
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select | Excel Programming |