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!!
Bookmarks