Last Cell Problem
That didn't work. I ended up copy the active data into another worksheet and
deleting the problem worksheet.
Thanks
"Flick Olmsford" wrote:
I use Excel 2003
CTRL+END will go to the last cell in the last row with any data. Try clear
all - data and formatting - for any and all cells in that row and column.
Also, why not just try and delete just row 65536 instead of 65K rows?
"CJN" wrote:
Somehow a worksheet I have thinks that I have somethink in the last row
which is 65536. I checked that row and I don't. Meanwhile the worksheet is
sluggish due to its size.
I tried deleting the bottom 65000 rows but it hangs my computer.
Is there another solution to this problem?
|