"END" of spreadsheet.

[Zac]

I know that CTRL/END takes me to the last cell in the S-Sheet. Can that be changed?

In other words my sheet really ends at lets say G40 not H50. I tried deleting rows 41 thru 50 but that still takes me to H50.

I'm trying to write a macro to automatically set my print area based on the "actual" end of sheet.

 

[Mark W.]

Did you save your worksheet after deleting the rows? Hint... hint.
This message was edited by Mark W. on 2002-02-27 10:28

 

[GeorgeAdamson]

Yeah, annoying isn't it?!
Here's a couple of ideas...

Try holding down 'End' and pressing the 'Down' arrow to get to the end of your data? (If it works, then record a macro while you do it to see what the command is)

Or try the .UsedRange property of the worksheet.