Hi, I need to run the solver for a column of 1800 target cells. The first target cell in the columns is H32 to be equal to zero, changing $B$2 and $C$2. Spreadsheet is called BetaNeutral. Right after the solution is found for each single row I also need $B$2 and $C$2 to be copied in $G34 and $H34. So keep it simple: 1. Run the solver for the first cell (H32) 2. Copy B2 and C2 into G34 and H34 3. Run the solver for the second cell (H33) 4. Copy B2 and C2 into G35 and H35
and so on. Can you guys provide me with a macro script to do the job? Thanks, Giorgio --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
