First, it's a BAD idea to name ranges (or pretty much anything else) with an Excel object, method, or property name. It makes the code more difficult to read and can have unintended consequences.
Examples:
A sheet named "sheet"
a range named "select"...or "AutoFill"
In your situation, I'd name the range rngAutoFill
See if this works for you
Sub FillRange()
With Range("rngAutoFill")
.Cells(1, 1).Value = 1
.DataSeries Rowcol:=xlColumns, Type:=xlLinear, Step:=1
End With
End Sub
Is that something you can work with?
Bookmarks