minor tweek to merge cell macro needed

Hi guys,

Hoping you can help. I found the below macro to merge cells on this forum and I need it slightly editing if anyone would care to help!

Essentially this examines values in one column, and merges if the value below is identical. I need the code to examine multiple columns, so if A1=A2 AND B1=B2 then we should merge A1/A2 and B1/B2.

Thanks in advance for help!

Please Login or Register  to view this content.

That code worked fine for me. I had the following values

A1 = 1
A2 = 1
B1 = 2
B2 = 2

I then hilighted those cells before running the macro (because your code is set to loop through the 'selected' cells.

Do you get any error?

John

Thanks for the reply John.

It's not that I get an error - let me explain a little better. For example with the following values:

A1 = 1
A2 = 1
A3 = 2
A4 = 2
C1 = 3
C2 = 3
C3 = 3
C4 = 3

The code will merge C1 through C4. Whereas I would like it to merge A1/2 on the same row as C1 / C2 and then A3 / A4 on the same row as C3 / C4. Does that make sense?

Its probably possible to do that in your example but what would you want to happen if the cells were like this...

A1 = 1
A2 = 1
A3 = 1
A4 = 2
C1 = 3
C2 = 3
C3 = 3
C4 = 3

John

In the above example we would merge A1 - A3 and then C1 - C4. We would leave A4 as a single cell.

Does that help to clarify?

Attaching an example with raw data / macro result / desired result tabs.

Hope someone can help!

so the first column determines how the other columns are split?

e.g column 1 has ABC listed 3 times in a row followed by DEF listed 3 times in a row

and column 2 has XYZ listed 6 times in a row

you would want XYZ split into 2 merged cells (with 3 cells in each merge) ??

Thanks for the replies.

John - yep that is exactly how it works, the first column is an ID.

Roy - happy to go down an alternative route if you can advise, I realise many people try conditional formatting, but I wouldn't know how to code for it.

Thanks

Sam

just picking up on Roys suggestion and your conditional formatting comment - i would agree with Roy about merge cells getting messy.

if you were to colour the cells based on your criteria - how would you want the colouring to work? using my last post as an example, would you want ABC to be the same colour as the first 3 cells of XYZ?

Anyone...?