AutoFill Method of Range Class Failed

[Felix_Dragonhammer]

So basically the title says it all. I'm getting an error message on a bit of code as follows:

'
'SKU Tracking Sheet Update
'
Sheets("SKU Tracking Sheet").Select
Range("Y2") = Range("Y2") + 1
ColToRef2 = Range("Y2").Value
ColToRef3 = Range("Z2").Value
    For n = 7 To 183 Step 22
        Cells(n, ColToRef).Select
        Selection.AutoFill Destination:=Range(Cells(n, ColToRef2), Cells(n, ColToRef3)), Type:=xlFillDefault
    Next n
Cells(249, ColToRef).Select
Selection.AutoFill Destination:=Range(Cells(249, ColToRef2), Cells(249, ColToRef3)), Type:=xlFillDefault

The line in question is:

Selection.AutoFill Destination:=Range(Cells(n, ColToRef2), Cells(n, ColToRef3)), Type:=xlFillDefault

If necessary, I can provide the entire code that it's in. Thanks in advance for any help I get!

 

[JoeMo]

The destination argument in autofill must include the source range. If ColToRef is not equal to ColToRef2, that's not the case for the code you posted.

 

[Felix_Dragonhammer]

Another silly mistake. I don't know how much time I spent looking at that. Thank you so much!

 

[JoeMo]

Another silly mistake. I don't know how much time I spent looking at that. Thank you so much!

You are welcome - thanks for the reply.