Using Range with R1C1 notation in a macro

  • Thread starter Thread starter J
  • Start date Start date
J

J

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
 
Not sure what you are looking for. Perhaps:

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