Hi I'm having a bit of a problem with syntax here.

Sub Macro2()
    Dim rng As Range
    Dim rng_AutoFill As Range
    Set rng = Range("A1:E1")
    Set rng_AutoFill = rng.CurrentRegion
    rng.AutoFill Destination:=Range(rng_AutoFill)
        
    'rng.AutoFill Destination:=Range("A1:E36")

End Sub
If I replace rng.AutoFill Destination:=Range(rng_AutoFill) with the commented out version rng.AutoFill Destination:=Range("A1:E36") it works fine. I can select the rng_AutoFill range, I don't seem to be able to use it with a variable name.

Any comment gratefully appreciated.