Thread: How do I use R1C1 Reference Style in a Macro?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
  
Posts: 972
Default How do I use R1C1 Reference Style in a Macro?
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?
Reply With QuoteReply With Quote