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