Autofill On Activecell Resized

[JonesZoid]

Hi All

I have some code that selects an area within a worksheet, finds the last row.
I would just like to combine the 2, so that it now autofills the formulas down.

ActiveCell.Offset(2, 0).Resize(1, 12).Select
LastRow = Range("S" & Rows.Count).End(xlUp).Row

Please Help

Craig

 

[Andrew Poulsom]

Is it?

Selection.AutoFill Destination:=Selection.Resize(LastRow - Selection.Row + 1)

 

[JonesZoid]

Fantastic - Thank You For Your Help