Row Merge VBA Help

[liquidmettle]

Hi Everyone!,

It's been a while since I've posted, and a while since I've delved into the world of VBA, so I'm a little rusty.

I have a worksheet where data is entered, for every row, in either column A, B, C, D, or E. Data rows go from row 2 to row 1212.

I'm looking for code that will do the following:

If there is text in A2, merge A2 to O2/ If there is text in D354, merge D354 to O354, etc.

Essentially I want a macro to merge cells from the column that has data to column O (in every row, there will only be one cell with data across those 5 columns).

If column C had the data, I don't want columns A and B to be merged, just everything from C to O, and so on.

Thank you for your time in advance!

-LM

[Olly]

Try:

Please Login or Register  to view this content.

[liquidmettle]

Perfect Olly!

Worked like a charm.