Merge cells with same value, old code needs rework.

I tried to post in an old thread about a similar problem, but it was a 2 year old thread so I guess no one saw it.

However, this code merges all weeks that have the same weeknumber into one cell. The weeknumbers are listed in a column.
The code comes from arlu1201 and works perfectly for the matter where the weeknumbers are listed in a column and thus the cells in each row merge.

Please Login or Register  to view this content.

So my problem is that I have the weeknumbers listen in a row instead. (see ex.) I am not good at all with VBA and I wonder if the code can be rewritten to work for merging of columns instead.

Link to the old thread: http://www.excelforum.com/excel-gene...ml#post3738416

Thanks in advance.

Hi,

Can I respectfully suggest that you don't use merged cells - at least if they are to be used as the subject cells in formulae. Even if you want to see them as merged cells, then at least also have a row containing the week numbers in every cell and just hide that row if you don't want to see it.

Merged cells are just too much trouble and invariably cause problems.