Using Range with R1C1 notation in a macro
 

I have found plenty of references for using the Range
property in a macro ie: Range("A1:B5").select. In
addition I have used Cells(Irow,ICol) plenty of times.
Now I want to set a Range in a similar fashion as I did
the Cells using variables. Does anyone have any
suggestions?

Thank you

Using Range with R1C1 notation in a macro
 

Not sure what you are looking for. Perhaps:

Range(Cells(Row1, Column1), Cells(Row2, Column2))

--

Vasant


"J" wrote in message
...
I have found plenty of references for using the Range
property in a macro ie: Range("A1:B5").select. In
addition I have used Cells(Irow,ICol) plenty of times.
Now I want to set a Range in a similar fashion as I did
the Cells using variables. Does anyone have any
suggestions?

Thank you