Looping Macro through Specific Worksheets

Hello,

I've searched online for a macro that will repeat itself for all worksheets. What I have so far will loop through all the worksheets but I have to click on a message box to continue to the next worksheet. Even though I run this, it doesn't replace everything that needs to be replaced either. Any advice for getting this to loop correctly? I don't need it to search my two tabs that are titled "Srch" and "Rand". If it's possible to avoid those, it would be appreciated.

Please Login or Register  to view this content.

In case you're wondering, I'm creating a cypher and it won't work if the user runs the VBA code to Find All of symbols so I've temporarily replaced these symbols with a letter and a number and set it to replace these.

Thanks,
~BBS

Hi, the messagebox is aa question of deleteng that line of code, but the way you have written your code, well, that's not the way, there may be many ways to do this but this one works and ignores the two worksheets named "Srch" and "Rand"

Please Login or Register  to view this content.

Hope this one helps. I tested it and it replaced the values I placed

Try this.

Please Login or Register  to view this content.

Thanks for the answers and I do appreciate the help. Will try it now.

Edit:

Both worked great! Thanks! Norie, how does your code work if you don't mind me asking. I've been searching VBA tutorials for different ways to work with VBA but I haven't seen anything like your code yet. My current problem is just trying to figure out how each command works without getting stuck in a never-ending loop (accidently added one and had to ctrl alt del out of excel.