View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob J. Bob J. is offline
external usenet poster
 
Posts: 4
Default Selecting a Range Using a Variable

Thanks! This is exactly what I was looking for.


-----Original Message-----
yes, hope this example helps:

Sub SelectRows2To5InCol()
Dim Col
Col = 3
Range(Cells(2, Col), Cells(5, Col)).Select
End Sub

regards, Mika


"Bob J." wrote in message
...
Does anybody know what the marco command(s) are for
selecting a range of cells in a column using a

variable?


.