VBA__SOLVER PROBLEM, ERROR 1004
There is a cell named guess. A1
There is a cell named function which holds tfunct(guess) (ie links to the guess cell) A2
I then run "testsolve()" from another cell A3
Sometimes the error reads
"An internal error has occurred or memory was exhausted"
and sometimes it reads
ERROR 1004
method 'range' of object' _global' failed
see attachment
| Attachment | Size |
|---|---|
| solver_VBA_problem.xlsx | 8.68 KB |
pls login, edit ur post, and
pls login, edit ur post, and upload an example file showing only this problem