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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refedit controls and R1C1 notation 2
R1C1 notation in VBA code 7
R1C1 Notation in VBA 1
R1C1 Notation??? 1
merge cells part deux 2
Setting Range Name using R1C1 2
Assigning Range Names using VBA and R1C1 6
Handle a value from a Range instead of value of a Cell 8

Back
Top