View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCOR PCOR is offline
external usenet poster
 
Posts: 77
Default Selecting a range

Many Thanks
Have a great 2004
"Rob van Gelder" wrote in message
...
With Worksheets(1): Range(.Cells(1, 1), .Cells(Rows.Count,
1).End(xlUp)).Select: End With

"PCOR" wrote in message
. cable.rogers.com...
The code
Range("A2:A34").Select
will select A2 to a34
What code is required to select A1 to the last entry in Col A
Thanks

--
Norton Professional 2004 says this email is clean...believe it