How to trick a Dynamic Name to be Static when SOLVER is ON...
From my previous post today "DYNAMIC NAME", I had just been fed by Gary's
Student - single handedly- how to define a dynamic name by VBE....I need to
go to the next level....
The Dynamic Name must be static when I go to the SOLVER
function....Considering that the NAME contains the specific cell refs.
subject to SOLVER's fill in the blanks?
I hope Gary's Student can read this thread...to further continue the
multitask involve on the spreadsheet I am doing.
thanks for any reply....
|