Merge of Adjacent Columns having same values

[ashokkumarkolla]

Hi,

I am using a macro (Found in internet) to merge the adjacent cells having same values.

Working fine except it is merging even the cells are blank.

I need to skip the blank cells (without merging).

Attached the file for reference.

Thanks
Ashok

 

[Marc L]

Hi !

As merged cells is often the Evil if you need later a procedure
with this worksheet !

If you really want to merge cells, just test their values …
​

 

[vletm]

ashokkumarkolla
... and few more things to do

 

[ashokkumarkolla]

@vletm
It worked.
Thanks once again.
Ashok