That is correct. However I want the code to ignore that and only remove duplicates in cells that are not blank. So it may possibly be a loop code that if cell x <> '''' then compare cell x against other cellsin that range and delete duplicates