Can't really tell where you want the range to go.

But for starters (using R1C1 notation), adjust as needed.

Dim rng As Range
On Error Resume Next
Set rng = Range(Cells(Range("C22").Value, 1), Cells(Range("C35").Value, 3))
If Not rng Is Nothing Then
rng.Select
End If


--
steveB

Remove "AYN" from email to respond
"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