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.
Bookmarks