Macro for merging cells

[XLuser]

Hi,

I have a application that can export to XL.
This application also have the possibility to execute a XL macro after the exporting is done. Using this "execute macro" function I would like to merge cells that have the same data as the next row in the same column and this should only be done in the 3 first columns. See the attached bmp file for how it looks and should look.

I have searched the forum for examples without luck so I must turn to you excel/macro wizards out there since I'm no programmer .

Thx in advance

[XLuser]

Problem solved

I found an example published by Frank Kabel in Maj 2004 and with the help of others here at the company we modified it some and came up with this:

Please Login or Register  to view this content.