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

Top