Range formula in macro

[jaango123]

Hi All,
In my vba code, have the below line.
Selection.AutoFill Destination:=Range("C1:C12660"), Type:=xlFillDefault
The value "12660" is contained in a variable , a. How can I modify the above line to take the value from variable, a
something like
Selection.AutoFill Destination:=Range("C1:C& a &"), Type:=xlFillDefault

Could anyone please help on this

 

[VoG]

Try

Selection.AutoFill Destination:=Range("C1:C" & a), Type:=xlFillDefault

 

[jaango123]

Peter,

Thanks. That worked.

what should be for
ActiveSheet.Range("$A$1:$P$12660") to replace 12660 with the variable a

 

[VoG]

Try

ActiveSheet.Range("$A$1:$P$" & a)

 

[jaango123]

Awesome. Thanks, Peter