C
Conan Kelly
Hello all,
I have a spreadsheet of data, lets say 35,000 rows long. So when I do
a [Ctrl] + [End], it goes to the cell at row 35,000 (and the last
column of the data).
Now lets say that I run a macro that deletes 5,000 rows. So now the
last row is 30,000. But if I do a [Ctrl] + [End] again, it still goes
to row 35,000.
Is there any way to reset the spread sheet so it knows that the last
row/column of data has changed since row/column deletions?
Thanks for any help anyone can provide,
Conan Kelly
I have a spreadsheet of data, lets say 35,000 rows long. So when I do
a [Ctrl] + [End], it goes to the cell at row 35,000 (and the last
column of the data).
Now lets say that I run a macro that deletes 5,000 rows. So now the
last row is 30,000. But if I do a [Ctrl] + [End] again, it still goes
to row 35,000.
Is there any way to reset the spread sheet so it knows that the last
row/column of data has changed since row/column deletions?
Thanks for any help anyone can provide,
Conan Kelly