Autofill Issues - Dynamic

[jamescooper]

Trying to make this autofill dynamic by adding 2 cell variables - any ideas what I am doing wrong?

Thanks.

With Sheets("Data")
        .Range("A" & .Range("AD8") & ":" & "A" & .Range("AD10")).AutoFill.End(xlUp).Row
End With

 

[Fluff]

As this is basically the same question you asked here https://www.mrexcel.com/forum/excel-questions/1074127-vba-error-code.html#post5159757
(to which you have not responded), I am closing this thread
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).