AutoFill Destination Range Error: Expected List Separator

[SBF12345]

Greetings,

I am having trouble with the last line. I would like to use a variable "a" to define the last row in the Destination range but am receiving an error.

a = Cells(Rows.Count, "A").End(xlUp).Row           
    Range("J2:BC2").Select
    Selection.AutoFill Destination:=Range("Cells(2, "J"): Cells(a,"BC"))

Thanks!

 

[SBF12345]

got it, i needed a "," not a ":" there is also an extra """ in there for some reason.

 

[Dryver14]

Good stuff learning myself so did it come out something like

Selection.AutoFill Destination:=Range("J2:BC" & a)

 

[Fluff]

@Dryver14

you can do it that way, or you can do it like this

Selection.AutoFill Destination:=Range(Cells(2, "J"), Cells(100, "BC"))

 

[SBF12345]

@Dryver14 I stuck to the Range(cells version I suppose your construction is a bit shorter, oh well