View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alfred[_4_] Alfred[_4_] is offline
external usenet poster
 
Posts: 2
Default Selecting Till last row

Hi
I used the following code in a macro
Range(Selection, Selection.End(xlDown)).Select 'the same as
CTRL-SHIFT-DownArrow

This does not work if there is emty rows (only selects till it finds the
first emty row)

Is there another function to select till the last row that is populated ?

Thanks a lot
Alfred