Macro to remove duplicates (If duplicate meets all three criteria)

**adw223** · 08-01-2013, 05:25 PM

Also posted on: http://www.ozgrid.com/forum/showthre...877#post677877

I’m looking for help again.

I have attached a sample file and the code I have tried is below. I want to clear the contents of any cells in the range (“G5:X947”). If the cell is duplicated.
A cell is only duplicated if it meets all three criteria of Zone, DALI and Inverter.
I tried the following code which will remove duplicates but only if the duplicates are in adjacent rows. I need to expand this to remove duplicates if they are in any row.

Please Login or Register  to view this content.

**AB33** · 08-01-2013, 05:31 PM

I have not tested the code you have , but I would not surprise if it does not work as you have merged cells in your data.

**adw223** · 08-01-2013, 05:46 PM

I know it is better not to have merged cells but I have no choice there is a substantail amount of files and a lot more data on the files than what I have outlined and that is the way I received them. Unfortunatley I'm stuck with it.
I have worked around the merged cells by clearing the contents of the range of the two merged cells instead of just the cell. The code I have shown actually works and does remove duplicates but only if the duplicates are in adjacent rows. I need to get to loop through all the rows instead of the row just below the current cell.