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
--
HTH...

Jim Thomlinson


"Kevin" wrote:

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

For pre-2007:

Sub selectum()
Set r1 = Range("A3:N3")
Set r2 = Range("A4:IV65536")
Union(r1, r2).Select
End Sub
--
Gary''s Student - gsnu200735


"Kevin" wrote:

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

Thank you,
Jim Thomlinson & Gary's Student

-Kevin

"Kevin" wrote in message
...
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