Thank You! but the code you gave me deletes the cells that are repeated, but what i need is for the repeated cells to be merged.