help with dynamic autofill

[Guitarmageddon]

I have concatenated info from two other columns, in cell A9 and Im having trouble figuring out the VBA to autofill dynamically until the corresponding column B is at its end, which varies. Can anyone assist? This is getting inserted into a larger macro I have.

 

[Fluff]

Something like

   Range("A9", Range("B" & Rows.Count).End(xlUp).Offset(, -1)).FormulaR1C1 = "=rc2&"",""&rc3"

 

[Guitarmageddon]

Something like

   Range("A9", Range("B" & Rows.Count).End(xlUp).Offset(, -1)).FormulaR1C1 = "=rc2&"",""&rc3"

Do I need an autofill in there somewhere?

 

[Akuini]

Another way:

Sub a1077600a()
Dim n As Long
n = Range("B" & Rows.count).End(xlUp).row
Range("A9").AutoFill Destination:=Range("A9:A" & n)
End Sub

 

[Fluff]

Do I need an autofill in there somewhere?

Nope, just change the formula to whatever you want to concatenate. My code works on cols B & C & adds a comma between them