You are welcome and thanks for feedback
What your macro was missing the command to run solver i.e.
I also dim'ed i as an integer. Not essential but makes macro a tad faster as excel then knows what i is supposed to be instead of guessing.
Not really sure about your line
as solver only works on the active sheet. This is a build in feature of solver as it makes solver work faster.
Alf
Ps as this seems to solve you problem don't forget to mark this thread "Solved"
To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
Bookmarks