How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format

[Karthik Bhat - Bangalore]

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

 

[Titus]

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.