Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2002, Win XP
When I record the macro to simply put: =A1+B1 in a cell, I get: ActiveCell.FormulaR1C1 = "=RC[-2]+RC[-1]" This macro does put =A1+B1 like I want, but why is the actual code written in R1C1 style? It is difficult to read later. I realize that I can manually change the code line to look like I want, but in a complex formula this can be tiresome and prone to errors. Thanks for your help. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using INDIRECT & R1C1 Ref style | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) |