How to change multiple formulae by looping

[pauluk]

Hi All,

How can can i loop the below formula through a range of cells?

each cell contains a formula be it =N$1*$G119 or =5*$G119

how can i loop a to change the formula to =N$18*0.05 or =5*0.05

the range is N3:W284

I think i just need to loop the folloing through the range but have ha
no joyu as yet

ActiveCell.FormulaR1C1 = "=R1C*0.05"

I have tried:
For each cell in Range("N3:W284")
ActiveCell.FormulaR1C1 = "=R1C*0.05"
Next Cell

but it changes all the cells to the same formula rather then keepin
the left handside of the formula as it is and just deleting an
changing the right handside to 0.05

I help please.

Thanks
Pau

 

[Guest]

Try:

For each cell in Range("N3:W284")
Cell.FormulaR1C1 = "=R1C*0.05"
Next Cell