View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach Jef Gorbach is offline
external usenet poster
 
Posts: 59
Default Determing a range from numerical data


"Moises" wrote in message
...
I am trying to code the corresponding range of cells as the result of
numerical data without success.

What would be the code of the following example :
Range A12 to C22
A12 is known and C22 is the result of a counter that gives the number 22

Range("A22: ????? ).Select

Thanks for your help.
Moises


Range("A22:C"&counter).select should do it