"END" of spreadsheet.

Zac · Feb 27th, 2002, 11:13 AM

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. · Feb 27th, 2002, 11:27 AM

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 · Feb 27th, 2002, 11:35 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 11:13 AM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	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.

Feb 27th, 2002, 11:27 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Did you save your worksheet after deleting the rows? Hint... hint. [ This Message was edited by: Mark W. on 2002-02-27 10:28 ]

Feb 27th, 2002, 11:35 AM	#3
GeorgeAdamson New Member Join Date: Feb 2002 Posts: 14	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.