Thread: Select Cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Select Cells

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