How do I use R1C1 Reference Style in a Macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to write a macro that references the cell 2 rows above the
current cell. I typically use hard references ie Range("D7").Select but that
won't work for this instance. I know that R[-2]C would work but i'm not sure
how to incorporate or call that in a macro. Can anyone help?
 
You probably want to use offset which moves your reference something like
this...

msgbox Activecell.Offest(2,2).Address
or
msgbox Range("A1").offset(2, 2).Address
or
msgbox Cells(5, 5).Offset(2, 2).address
or
msgbox Cells(5, "C").Offset(2, 2).address
 
Something like:

activecell.offset(-2,0).select


I would like to write a macro that references the cell 2 rows above the
current cell. I typically use hard references ie Range("D7").Select but that
won't work for this instance. I know that R[-2]C would work but i'm not sure
how to incorporate or call that in a macro. Can anyone help?
Click to expand...
 
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

Turn off R1C1 reference style via VBA 1
R1C1 style reference as Condition 9
refer to a particular cell in r1c1 style 11
Setting Range Name using R1C1 2
Macro to line up rows 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
How do i refer to cell contents in a macro? 1
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top