Microsoft's square root table macro

  • Thread starter Thread starter david.l
  • Start date Start date
D

david.l

I'm having trouble getting Microsoft's square root table
Visual Basic macro loop program that is supplied on the
following support page to work properly.
The page is -
http://support.microsoft.com/default.aspx?
scid=/support/excel/content/solver/solver.asp#005

Has anyone had success in finding out a fix?
Being new to Visual Basic and now solver, I find it a bit
frustrating to try to get it to work.
It comes up with the error:-
Solver:An unexpected internal error occurred, or available
memory was exhausted.

Thanks for help in advance,
David Langedock
 
The referenced code works for me under Excel 2000 SR-1, but produces the
error you describe under Excel 2002 SP-2. The error occurs the first
time the SolverOK function is called.

The Knowledge Base article

http://support.microsoft.com/default.aspx?scid=kb;en-us;821430

indicates that the problem was introduced with Microsoft Office 2000
Service Pack 3 (SP-3), and links to a patch for that specific version.
I saw nothing in the Knowledge Base either acknowledging or offering
fixes for the problem in Excel 2002.

Jerry
 
Back
Top