VBA: Multiplying columns into new column

[JetSetDrive]

I need a VBA code that will multiple column A*B and insert it into column C.

Range(C:C).Formulat = "A1*B1

The reason this code is tricky for me is because the code will be ran on worksheets with varying amounts of rows, so it needs to only be ran for active rows.

The data also has a header, if I have to put the data back later it is not a big deal.

I appreciate the help. I have spent too long trying to figure this out.

 

[Joe4]

Welcome to the Board!

Try this code:

Sub MyMacro()

    Dim lr As Long
    
'   Find last row with data in column B
    lr = Cells(Rows.Count, "B").End(xlUp).Row
    
'   Populate formulas in column C from row 2 to last row
    Range("C2:C" & lr).FormulaR1C1 = "=RC[-2]*RC[-1]"

End Sub

 

[Fluff]

Hi & welcome to MrExcel
How about

   Range("C2", Range("A" & Rows.Count).End(xlUp).Offset(, 2)).Formula = "=A2*B2"

 

[JetSetDrive]

Compile Error : Expected End Sub

 

[JetSetDrive]

Sorry, never mind.

I accidentally deleted part of the previous sub

 

[Fluff]

Glad we could help