MamboKing
07-07-2008, 09:18 AM
This function
=input2Solver(H3, H4)
is into an Excel cell and is meant to simply calculate a value.
I'd need to monitor its evolution by displaying Public variables in other cells, hence I add in its body something like Range("Q2") = myPublicVar.
Results:
the function input2Solver() aborts as soon as it encounters such instructions. And it aborts also when it encounters a Call Sub if that Sub contains such instructions.
Ths point is that I have other functions that are just OK with such display instruction and execute it properly. The difference is that these other functions are not called in Excel cells but are called in VBA modules!
Bottom line:
How can I display public variables on cells during the execution of a function called from a cell?
=input2Solver(H3, H4)
is into an Excel cell and is meant to simply calculate a value.
I'd need to monitor its evolution by displaying Public variables in other cells, hence I add in its body something like Range("Q2") = myPublicVar.
Results:
the function input2Solver() aborts as soon as it encounters such instructions. And it aborts also when it encounters a Call Sub if that Sub contains such instructions.
Ths point is that I have other functions that are just OK with such display instruction and execute it properly. The difference is that these other functions are not called in Excel cells but are called in VBA modules!
Bottom line:
How can I display public variables on cells during the execution of a function called from a cell?