Macro error when ran on multiple sheets on workbook (even though macro works)

I have a macro that works like I want it to and runs through every sheet in the workbook. But when it finishes I get a pop-up error, even though it worked. Can someone tell me in my code what is wrong to remove the error.

Please Login or Register  to view this content.

I know the error has to be caused in this particular string of code:

Please Login or Register  to view this content.

Here is a picture of my error after clicking on debug:
error.png

Try this.

Please Login or Register  to view this content.

I tried to mimic what you did with the first part of my macro and could not get it to work. Your code work excellently...any suggestions on this one because I get the same error message as the one you fixed. I'm trying to do the same thing, go through each sheet on the workbook. What do I have that is wrong?

Please Login or Register  to view this content.

This might work, I say might because I'm not 100% sure what you are trying to do or the error you are getting.

Anyway, here's the code.

Please Login or Register  to view this content.