Need VBA code for formula reference in loop

[Elysium4Eternity]

Hello, I'm fairly new to VBA and there's something I'm struggling with.

So I want to get the answer of cells G3*I3 in cell K3. That's not a problem so far. But now I want a code so that in K6 I will have the answer of G6*I6, in K9 the answer of G9*I9, and so on. In my original file I need to repeat this about 1000 times. I'm having a really hard time figuring this out...

Thanks in advance!

 

[adamvas69]

Hi, try this:

<code> Sub macro()
Dim i As Integer
For i = 3 To 1000 Step 3
Cells(i, 11).Value = Cells(i, 7).Value * Cells(i, 9).Value
Next i
End Sub

Replace 1000 by number of your rows.
<code></code>
</code>

 

[Fluff]

Hi & welcome to MrExcel.
how about

Sub AddFormula()
   Dim i As Long
   For i = 3 To 1000 Step 3
   Range("K" & i).FormulaR1C1 = "=rc[-4]*rc[-2]"
   Next i
End Sub

 

[Elysium4Eternity]

That's the code I was looking for. Thank you alot!

 

[Fluff]

Glad we could help & thanks for the feedback