Auto fill and fixed value

[Maggielove]

Is it possible to fill a range with a fixed value using auto Fill? I have a macro which should insert the value T9 into a range of cells, but the number part keeps incrementing, T9,T10,T11 etc. How can I stop this happening please?

my current code is
Range (“I2”).Value =T9
Range (“I2”).Autofill Destination:=Range(“I2:I” & Lastrow)

Any help appreciated
thank you

 

[Joe4]

Just use this one line:

Range("I2:I" & Lastrow).Value = Range("T9").Value