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
 
Top