NoSparks,
I would now like to create another program but that does what this code originally was made to do......delete rows if data is the same. I would use the original code I received but yours is so much better.
I believe all that needs to change is to add a "Not" so the code is:
Code:
If Not fndRng Is Nothing Then 'was not found
Correct?