Dear Alan,
I had some issues with my laptop and just got it fixed.

I had mentioned in my previous post #17 that I have test the macro both in the file as well is the Normal Template, probably you missed it.

Now what I am going to tell would surprise you as it has surprised me as well.
When I run the macro the folder 2_ KEEP DUPLICATE RECORDS files got created with the error and debug message as posted previously.

The file was in the download folder and the macro was in the Normal template.

When I run the macro. All my files - I mean all docx, xlsx, pptx, jpgs etc etc moved to some where I don't know where.

There is really strange. I am just sharing this with you that this has happened in my download folder.
I have tried looking for it in other folders and I could not find it anywhere in my hard drive.

All the folders are intact but the files have moved to some where I have not idea what so ever.

Not a single files is there in the download folder. Only folder remains

I really appreciate all the help and time you have taken to look up in this matter. But now this files disappearing is something I thought I would share with you.

Thanks once again.