View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J J is offline
external usenet poster
 
Posts: 1
Default 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