| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| Turn off R1C1 reference style via VBA | Excel Programming | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| How to code with the R1C1 Style of Reference? | Excel Programming | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
Threaded Mode
