Simple Merge Cells for One Row (Macro)

[boss1982]

hi,

please i want a macro to merge all continues duplicate values, but plz note that all r in the same row.

if possible also, please disable the warning popup message 1.png

sample is attached

thanks.

[OllieB]

Try

Please Login or Register  to view this content.

[boss1982]

hi ollie

i tried your macro, it is working after column H only, where is the code to make for the whole first row for example?
thanks.

[OllieB]

Not sure what you mean!

It works perfectly on the example you gave me, all relevant cells on row 1 are merged.

Are you sure you are testing correctly?

[boss1982]

ok i found the problem,

if you copy row 1 and paste it to row no. 2,3 & 4, the macro will also merge them, not only the first row as what i want.
please i want to to merge the continues duplicate values only in the first row.

and please tell me how if i want to merge row no. 2 or 3 or....etc. separately. (not all together)
thank u.

[OllieB]

If you only want to merge row 1

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If you want to merge other rows, just indicate from which row to which row.

[boss1982]

ok i found the problem,

if you copy row 1 and paste it to row no. 2,3 & 4, the macro will also merge them, not only the first row as what i want.
please i want to to merge the continues duplicate values only in the first row.

and please tell me how if i want to merge row no. 2 or 3 or....etc. separately. (not all together)
thank u.

[boss1982]

Thank you Ollie.

it is working perfectly.

[kvsrinivasamurthy]

Pl try this code.It is only for Row 1 only.

Please Login or Register  to view this content.