Autofill Down in VBA

[coolkidz33]

I really don't understand why Excel is so complicated when you autofill down in picking the correct range. Even if I record a macro and use Relative cell references, it still hard codes a range into the command. I have a formula in cell P2 that I want autofill to the bottom of the table. I recorded the macro below using Relative References thinking it would work. It does when there are only 13 rows. However, sometimes there are more than 13 rows. I am sure there is an easy macro to do this to the bottom of the column. Can anyone help with this? I would appreciate it. Jon




Range("P2").Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A13")
ActiveCell.Range("A1:A13").Select

 

[MARK858]

Try...

Sub Pfill()
Range("P2").AutoFill Range("P2:P" & Range("A" & Rows.Count).End(xlUp).Row)
End Sub

 

[coolkidz33]

Wow that was simple. Thank you so much. No matter how much I try to learn about VBA, these little things trip me up.