View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rml rml is offline
external usenet poster
 
Posts: 50
Default 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....