Reseting the last row/column

[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

 

[uf_gator]

Here is an article from Msft on the topic:
http://support.microsoft.com/?kbid=244435

I have installed the add-in provided here and it works well. If you
need to do this frequently you may want to look into adding it.

 

[Bob Phillips]

See http://www.contextures.com/xlfaqApp.html#Unused

--

HTH

RP
(remove nothere from the email address if mailing direct)