Identifying and selecting adjacent duplicate values

My goal is to select and merge all adjacent duplicates in a given column. The obstacle I've come to is selecting the duplicates to merge. I've written code to insert a 'helper column' that returns a 1 at the top and 2 at the bottom of all ranges to be merged. I have yet to figure out any way to use this column to actually select the appropriate cells. I've also thought about inserting a new row to separate the ranges to be merged and to create a natural breakpoint.


Attachment 499643

If it's easier to visualize, I want to merge all cells between the borders, or all cells in each range from 2->1.

Thanks!

Hi
I don't think your helper column is needed. This macro should merge all cells in the active column with duplicate values, starting at the active cell and continuing down until it finds s blank cell.

Please Login or Register  to view this content.