• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Merge of Adjacent Columns having same values

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
 

Attachments

  • ak.xlsm
    15 KB · Views: 9
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 …
 
Back
Top