Looping VBA code for Goalseeking skipping certain named sheets

Hi!

I tried to do something like this a year ago or so but it never quite came out how originally planned it and now its more important that I get it right.

I have a master sheet with data that references many sheets in the same wb. On each of the many sheets I need one cell to be goalseeked to zero. Right now I have the following few lines of code on each sheet that requires goalseeking:


[

Please Login or Register  to view this content.

This was sufficient for a while but what I need now is a looping code I can activate with a button. One that goes through each sheet in the wb but skips certain named sheets.

or even better...

Is it possible that if I had a list of the names of the certain sheets that I wanted the code to run on that if I selected this list of names and ran the code it would only run on those sheets?

your help is appreciated.

Thanks,

G

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks