Marco keeps looping through each sheet

The macro I have below keeps looping through each sheet, albeit its what the macro was designed to do, however, I want it to cycle through each sheet 'silently' until it has cycled through each sheet and then present the msgbox "unable to locate"

Here is the code that I am using currently:

Please Login or Register  to view this content.

Originally Posted by MarvinP

Hi klturi,

Perhaps some VBA at the top of your code like:

Application.ScreenUpdating = False would make it "silent"?
See an example at:
http://www.excely.com/excel-vba/screen-updating.shtml

I tried using both screenupdating and displayalerts but both failed to prevent the screen from giving the message for each sheet in the workbook.

So, almost immediately after I posted my last response I found a thread on a competing forum that had the exact same scenario, very code, but was able to get the job done.

Not sure if its deemed acceptable to post the link so I will omit it for now.