Range as Variable

[Ananthak275]

Hey,
Does anyone know how i can change my range to variables?
This is what ive been trying and its failing:

ColumnAutoFilled: "A"
StartRow= 2
LastRowColumn: "E"

range("A2").select
Selection.AutoFill Destination:=Range("ColumnAutoFilled&StartRow : ColumnAutoFilled & Range(LastRowColumn & Rows.Count).End(xlUp).Row) <- this line is giving me error
Range(Selection, Selection.End(xlDown)).Select

this is my original code to autofill A until the last row of E that works:

range("A2").select
Selection.AutoFill Destination:=Range("A2:A" & Range("E" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select

 

[RoryA]

Try:

Selection.AutoFill Destination:=Range(ColumnAutoFilled & StartRow & ":" & ColumnAutoFilled & Range(LastRowColumn & Rows.Count).End(xlUp).Row)