VBA Code Required

[hrayani]

Hello,

I need a Vba code for the following..

Everytime a value changes in cell L1 then

In CELL M3 = L3*L1
In CELL M4 = L4*L1
In CELL M5 = L5*L1

REGARDS TO ALL

HUMAYUN

 

[VoG]

Why do you need a macro. Can't you just enter those formulas in the cells?

 

[hrayani]

CEll L1 is constantly updating with a click of the button and the range (M) is very long. yes i have manually typed in the formula but thats slowing down the updating speed of cell L1.

Just thought that a macro would alow cell L1 to update a bit faster.

 

[VoG]

VBA is generally slower than formulas.

 

[hrayani]

Thanks