Recording a macro with relative reference
Hi
I have a task that I have to do repeatedly and so I want to record a macro for it. Every time I have to do a conversion by multiplying the number with 3. While recording the macro , I have clicked on relative reference button and then I perfom the calculation. But the macro record
ActiveCell.FormulaR1C1 = "=8*3
where as I want that it should not record 8
Any help plz
Thank
Shilps
|