Selecting Till last row

  • Thread starter Thread starter Alfred
  • Start date Start date
A

Alfred

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
 
you can try this

Range(Selection, Cells(Rows.Count, Selection.Column).End(xlUp)).Select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Name changes with dates and Deleting Rows of Zeros 0
Delete records from result-cell after a find-function call 7
variable number of rows. 2
Subtotal Formatting 2
Loop Till the end of used Cell 2
"Run-time error '1004' 5
Row find Macro 9
macro code selecting moving range 3

Back
Top