I'm trying to automatically fill down my formulas in a macro but it doesn't seem to be working.
My values start in row B9 and don't always go down to a certain row # so I want to be able to copy down the formulas in columns E9:T9 until it finds no more data in column B.
What's wrong with my code?
Dim LR As Integer
LR = Range("B9" & Rows.Count).End(xlUp).Row
Range("E9").AutoFill Destination:=Range("E9:T" & LR), Type:=xlFillDefault