Run a simple goalseek macro in every sheet except a few

Hi There,
I have tried to use answers from previous posts on this subject but nothing works unfortunately. I just want to run a very simple goalseek macro in every sheet except some specific sheets when I use the shortcut (ctrl b in this case)

My macro is currently this:

Sub balance ()

Range ("U61") .Goalseek Goal :=0, Changingcell:=Range ("e25")
Range ("z56") .Goalseek Goal :=0, Changingcell:=Range ("z59")

End Sub


I want to run this macro on all sheets in my spreadsheet except ones with the following names:

Loadcombs required
Inputs & Weight Distribution
Long Summary
Tran Summary
Trans Rollout

Everything I have tried so far either only runs on the selected sheet or tries to run on all of them and bugs in those 5.

Please help!!

Please Login or Register  to view this content.

Now....if you're in Southampton doing VBA based reporting then you're either working for Carnival or B&Q. Which is it?

@bellygas, beat me to the punch. my stab at it:

Please Login or Register  to view this content.

Many thanks for your swift reply!

I actually work for a Civil Engineering company nearby - the spreadsheet concerns structural design of a marine structure!

I have obviously messed something up as when I copied your solution between Sub balance () and end sub, it says I have a compile error: syntax error when I try to run it... I am very new to macros and coding in general so treat me as a total moron!

No worries. copy and paste your whole macro.....but put [ code ] tags around it

Please Login or Register  to view this content.

Many thanks to you as well dmcgov!

When I run your suggestion I get a run time error '28' - out of stack space. Is this something to do with lack of memory or too many sheets?

Please Login or Register  to view this content.

https://docs.microsoft.com/en-us/off...space-error-28



And you need to put [ code ] at the start (without the spaces) and [ /code ] at the end. And when I say the whole macro, I mean all of it with the extra stuff you've just added.

Please Login or Register  to view this content.

Those are the 2 I tried

@ChrisGeorge89 there could be 3 issues with the error.
1) you have an old (and not updated) excel.
2) you have too many programs open on the taskbar
3) your windows installation may need to be updated.

let me know if that helps.

One more question. When you get the syntax error, which line is highlighted?

It highlights the text in line Range ("u61") etc. and then the Sub balance turns yellow afterwards ( I hope that makes sense)

try this:

Please Login or Register  to view this content.

Capture.JPGCapture.JPG

Unfortunately I am still getting the syntax error on that one as shown (without error box) above

@dmcgov - on your original suggestion should that be as a seperate macro to the one called balance? As it never actually says anything about the goalseek, it only 'calls' balance

Take the spaces out.

ie, instead of

Please Login or Register  to view this content.

put

Please Login or Register  to view this content.

It works!!

Thank you both so much for your patience and your help!!