Concatenate using VBA

[Steve_123]

Hi there

I'd like to concatenate A2 & B2 & So on until P2, then repeat each row for the whole range.

The range size will change each time, but the concatenation should always start at A and finish at P.


Thanks in advance for help.

Steve

[Leith Ross]

Hello Steve_123,

Where will the output go?

[Steve_123]

Sorry Leith, into Q2 etc

[Leith Ross]

Hello Steve,

Try this macro.

Please Login or Register  to view this content.

[Steve_123]

Thanks Leith