PDA

View Full Version : [SOLVED] Multiplied of 2 column



parscon
09-06-2013, 05:00 AM
Dear Friends
I need a VBA code that start from row 20 and do Multiply of E20 X F20 = G20 and do this until latest row of sheet that I have data.

For example of I have 5 row it will be :

E20 X F20 = G20
E21 X F21 = G21
E21 X F21 = G22
E21 X F21 = G23
E21 X F21 = G24

Thank you very much.

parscon
09-06-2013, 05:04 AM
Sub test()
Dim LR As Long
LR = Range("C" & Rows.Count).End(xlUp).Row
Range("E1:E" & LR).Formula = "=C1*D1"
End Sub