What's wrong with this code?

[YYF330]

I'm using Macro recorder but want to not fix the selected range. But the code can't go through. What's wrong with the following code? and how to debug?:crying:


Selection.AutoFill Destination:=Range("I2", "I" & Cells(Rows.Count, 9).End(xlUp).Row)

[Bob Phillips]

Maybe


lastrow = Cells(Rows.Count,"I").End(xlUp).Row
Selection.AutoFill Destination:=Range("I2").Resize(lastrow-1)

[SamT]

Selection.AutoFill Destination:=Range(Range("I2"), Cells(Rows.Count, "I").End(xlUp))