Selection.End(xlDown) with Rows selected

T

Tokash

This should work:

For just selecting the column "N" range would be:
Range("N1", Range("N1").End(xlDown)).Select

To select all the rows of the N column range:
Range("N1", Range("N1").End(xlDown)).EntireRow.Select

Tokash
 

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

Problem with date formatting 5
Copy columns and paste with blank column between 5
Autofill Dynamic Range of Cells 2
Range to find matches to copy values 0
Range to find matches to copy values 7
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Subtotal Formatting 2
Remove Identical words 0

Top