Deleting Rows CTRL End to Blank

  • Thread starter Thread starter Shauna Koppang
  • Start date Start date
S

Shauna Koppang

Say I have a 100 row table and I delete 50 rows, Excel
remembers the last position when you navigate using CTRL
END. It goes to a blank at Row 100 in the bottom right
corner where the spreadsheet was, not to where it is now.

Does anyone know how to change this so it goes to Row 50
instead, where the actual table currently ends?

Thanks!
Shauna
 
Manual you must press the Save button to reset it Shauna

With VBA you can do this

Sub test()
Rows("10:40").Delete
ActiveSheet.UsedRange
End Sub
 
Feel silly, but Thanks! As simple as saving. Thanks for
the code, that may help at some point.

S.
-----Original Message-----
Manual you must press the Save button to reset it Shauna

With VBA you can do this

Sub test()
Rows("10:40").Delete
ActiveSheet.UsedRange
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Shauna Koppang" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
Back
Top