Macro Copying Multiple Equations to Last Row

[wildcard369]

I am currently trying to get a macro to basically copy the formulas I have set up from P15:AN15. Each column is a different equation and I need it to run the equation all the way down to the last row of column O. The spreadsheet I am using currently has multiple tabs but, will only need to pull all data from it's current tab.

Any suggestions or help would be greatly appreciated.

 

[JoeMo]

Welcome to the forum!

Sub PullEqnsDown()
Dim lR As Long
lR = Cells(Rows.Count, "O").End(xlUp).Row
Application.ScreenUpdating = False
Range("P15:AN" & lR).FillDown
Application.ScreenUpdating = True
End Sub