Concatenate 2 Columns in VBA

Question

I have 2 columns (column F and G), let's say they both go up to row 10. In row S, I want a concatenate statement: F(G)

I've tried:

SHEET.range("S2:S2" & LastRow).FormulaR1C1 = "=CONCATENATE(RC[-13],""("",RC[-12],"")"")"

and

SHEET.column(18).FormulaR1C1 = "=CONCATENATE(RC[-13],""("",RC[-12],"")"")"

The problem with either is that after the 10th row, the formula keeps running such that every cell goes "()". How do I edit the macro to end when there's no more data in column F and G?

Scott Craner · Accepted Answer · 2019-01-18 15:49:50Z

2

with:

range("S2:S2" & LastRow)

if LastRow is 10 then the string will be S2:S210 as you have the 2 in the second reference. You want to remove that:

range("S2:S" & LastRow)

So:

SHEET.range("S2:S" & LastRow).FormulaR1C1 = "=CONCATENATE(RC[-13],""("",RC[-12],"")"")"

answered Jan 18, 2019 at 15:49

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Concatenate 2 Columns in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related