MrExcel Publishing
Your One Stop for Excel Tips & Solutions

CTRL-END question


Posted by PQ on January 28, 2002 1:31 PM

I have a sheet that had a formula and row 5000, but after tweaking it some the final row entry resides at row 3000. Unfortunately, now whenever I CTRL-END to get to the bottom I end up at row 5000. I'm sure there is an easy fix for this. Any suggestions?

Thanks,
PQ


Posted by Mark W. on January 28, 2002 1:36 PM

Delete rows 3001:5000 and re-Save your workbook.

Posted by Juan Pablo G. on January 28, 2002 1:39 PM

Another option. After deleting rows 3001:5000, go to VBE, hit Ctrl G, and in the Inmediate window type

ActiveSheet.UsedRange

Juan Pablo G.

Posted by Mark W. on January 28, 2002 1:40 PM

BTW, a fast way to select 3001:5000 is...

Type Control+G, enter 3001:5000 as the
Reference, and press [ OK ].

Posted by PQ on January 28, 2002 1:41 PM

Simple. Thanks Mark!