Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
Hey,
Does anyone know how i can change my range to variables?
This is what ive been trying and its failing:
this is my original code to autofill A until the last row of E that works:
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