VBA Fill to last Row (multiple columns)

Hi,

I'm trying to write a macro which automatically fills formulas I have from row O10 to U10, all the way down to the last row of data as prescribed by column A.

So far I have this macro that I found on this forum and I got it to work for data in column O only.

Can someone help me modify this macro so that it will fill all the data from column O to U?

Sub FillFormula()
Dim LastRow As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row

Range("O10").AutoFill Destination:=Range("O10:O" & LastRow)
End Sub


Thanks!

Please Login or Register  to view this content.

I tried that, but I"m getting an error message

"Autofill method of range class failed"