'select range using variables then filldown

I want to select cell F2 and name it "first", select cell q2 and name "last" and then copy that range down to the last row with the last row defined by the last used cell in column A.

I have tried to do this with the following.

Range("f2").Select
Set FIRST = ActiveCell
ActiveCell.Offset(0, 11).Activate
Set LAST = ActiveCell
Range(FIRST, LAST & Range("A" & Rows.Count).End(xlUp).Row).FillDown

If I change Range(first, last) to range(f2:q2) it works perfectly.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source