Select Cells

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Dear NG:

I know I saw something similar to this here before but I
can't find it anymore.

I want a macro that selects cells A3 thru N3 and then
all cells down the page.

Thanks,

-Kevin
 
Assuming that you want only the populated cells and that Column A is
populated to the end of the data then this should do it...

Sub Test()
range(cells(rows.count, "A").end(xlUp), range("N3")).Select
End Sub
 
For pre-2007:

Sub selectum()
Set r1 = Range("A3:N3")
Set r2 = Range("A4:IV65536")
Union(r1, r2).Select
End Sub
 
Back
Top