Identical Solver for Many Worksheets

Y

yauchildchew

Joined
Jun 19, 2010
Messages
2
Reaction score
0
(SOLVED) Identical Solver for Many Worksheets

As indicated by the title, I have an excel files with many worksheets. All data are arranged in similar layout.

I used macro recording to record my 1st solver; which includes from the target cells to the constraints.

When I try to run the same macro code for other worksheet, "Sub or Function are not defined" pops up.

What is wrong?

Thanks.

SOLUTION:
turns out I need to go to VBE> Tool> Reference, and to select Solver.
And then it works fine.
Thanks all!
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver programming questions 8
Solver with VBA 1
Macro for Solver 2
Macro tool for solver 3
Error message when using the Solver in a VBA macro loop 2
How to record macro for Solver in Excel? 7
Solver programming in VBA 3
what does error message "too many adjustable cells" mean in solver 1

Top