View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 3
Default Need help writing Excel macro to solve a cell in each row of a spreadsheet


I am trying to write an Excel macro to run solver in order to iterate a
solution for a cell in each row in a spreadsheet. Each row contains the
target, changing, and contraint cells. However, I have over 10,000 rows
that need to be iterated. The problem I'm having is getting the macro to
move to the next row after one has been solved. Any help would be
greatly appreciated.



*** Sent via Developersdex http://www.developersdex.com ***