Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format
Hi
Searched the group for a solution but couldn't find one So here's my problem: Whenever I record a Macro Excel records formulas in R1C1 Style Example: Range("A4").Select ActiveCell.FormulaR1C1 = "=+R[-2]C+R[-1]C" Now I do not want Excel to record in this R1C1 style. I want Excel to record the formula in ActiveCell.Formula format Range("A4").Select ActiveCell.Formula = "=A2+A3" Now What is that I have to do to make Excel record formulas in the ActiveCell.Formula = format every time I use Macro recorder to record macros. Any info on this would be helpful.... Thx in Advance Karthik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format
When you record a macro, a small widow pops up with the stop button on
it. the other button is the relative button, if you press it before recording your macro it gives you the direct cell address not the R1C1 style. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell.FormulaR1C1 | Excel Discussion (Misc queries) | |||
ActiveCell.FormulaR1C1 | Excel Programming | |||
ActiveCell.FormulaR1C1 | Excel Programming | |||
activecell.formular1c1 | Excel Programming | |||
ActiveCell.FormulaR1C1 | Excel Programming |