Amend macro to run through all sheets except two

**rajsa** · 02-05-2009, 10:46 AM

Hi everyone,

I have found and adapted a macro (below) that searches all worksheets for a specific value (entered by the user in a specfic cell) then displays a list of hyperlinks to the matching cell locations.

I now have a couple of sheets I don't want to be included in this macro ("Master List" and "Pivot Table") but I'm really struggling to find a way of amending the macro to exclude these. I've searched and tried a couple of ways but I get errors and I think I'm not knowledgable enough to know where to put each bit of code.

Any help gratefully accepted

Please Login or Register  to view this content.

**royUK** · 02-05-2009, 11:11 AM

I can't test this without the workbook so try this on a backup file

Please Login or Register  to view this content.

**rajsa** · 02-05-2009, 11:22 AM

That works perfectly, thank you! It's a solution I haven't come across elsewhere, I will have a proper look at what it does and hopefully learn something