Try one of the fixes at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 13:27:02 -0700, Youngblood
wrote:

Using Excel 2002; I am subtotaling and removing subtotals from data. After I
remove subtotals and hit Ctrl End, I am at a cell that is several blank rows
from the end of my rows of data. How can I cause my Ctrl End function to go
to the last cell in ss that contains data?

Thank you. I am a new subtotal user.