[RESOLVED] Dynamic Autofill Range (Both start and end variable)

[InderpalHothi]

Hi guys

I have calcualted the first and last rows being used in a sheet.

FirstRow and LastRow are variables which will change frequently.


I now need to autofill a formula i have to cover the range.

Usually I would just do

Selection.Autofill Destination:=Range("a1:a" & LastRow)

Does anyone no the notation for what I want? I tried


Selection.Autofill Destination:=Range("a & FirstRow:a" & LastRow) but didnt work, just struggling with the notation.

Thanks

[vbfbryce]

Maybe this instead:

Range("a" & firstRow, "a" & lastRow)