Merge cells which contain the same data

[Cesarina]

Hello,

I would like to create some code which checks a row of data and merges the cells which contain the same data.

The data in Excel is as such:

A1 B1 C1 D1 E1 F1
05-06 06-07 06-07 07-08 07-08 08-09

The outcome for the above example would be that cells B1 and C1 would merge and then D1 and E1 would merge as they contain the same data.

I am unable to simply merge them myself using the 'merge function' as they change on a quarterly basis and when they change it may be that different cells require merging, so I'd want to create a button that automatically does this for me.

Many thanks in advance for any help / advice you can give.

Thanks
Cesarina

[royUK]

I wouldn't used Merged Cells, they generally cause problems.