Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing a macro that will exit a spreadsheet | New Users to Excel | |||
When writing a macro in excel workbook, how do I refer to ea cell | Excel Programming | |||
Writing bitmap to Excel Spreadsheet | Excel Programming | |||
Writing to a excel spreadsheet is slow. | Excel Programming | |||
Writing a macro so that when saving a spreadsheet the data cannot be changed | Excel Programming |