calculate dynamic range and autofill formula

[batchjb69]

Hi

in the attached I need to join columns A & B. The range can vary from 100 rows to 1000 rows. Is their a macro that can be created to workout how many rows the data takes up and then in the next Colum a formula to join the data together. The macro would auto fill the formula.


range.xlsx

[stnkynts]

Try:

Sub RunMe()
Dim LR As Long

LR = Range("A" & Rows.Count).End(xlUp).Row

Range("C2").Formula = "=A2&B2"

Range("C2:C" & LR).FillDown

End Sub