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:
Back
Top