View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mika Oukka Mika Oukka is offline
external usenet poster
 
Posts: 6
Default Selecting a Range Using a Variable

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?