I have taken the new spread sheet that has had the dupes removed and tried the macro that you provided. I got the same error message. So I will be able to provide you a small sample spreadsheet to be analyzed by you. Will be later today.