View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barry T Barry T is offline
external usenet poster
 
Posts: 1
Default Using Excel Solver multiple times with macros

Is there a way to use dummy indices in macros in order to invoke Solver
multiple times? I want to solve for the value in column D by changing the
values in columns A and B, based on the value in Column C being constrained.
Rather than having cell references be definitive (i.e. "$A$1"), I want to put
the solver functions in a loop (An), where n varies up to 800, so that I can
invoke solver on 800 lines of data.