MsgBox count of unique values minus column D if equal B or C

Hi djfscouse,
I clicked your topic to see if I could help, but I see you already solved it yourself.

I took a quick look at your code and realized that some things seemed a little out of place (ie. DisplayAlerts was not re-set to TRUE before the code ended).

Since you were so kind as to post the code you have, and I could also use it, I thought I'd post a revised code that takes the "Select" out of the coding (which basically stops the code), and provide you with my improvements. I also used the "PasteValue" feature just in case there would be formulas in the original sheet. (Formulas would not carry over correctly to the added sheet.)

I'm using Excel 2010. But I'm pretty sure the VBA coding will work on your 2003 version, as I don't see any newer version language I did to the code that wouldn't work with 2003.
Please let me know if anything is different.

Please Login or Register  to view this content.