Re: Need help writing Excel macro to solve a cell in each row of a spreadsheet
- From: Tushar Mehta <tmUnderscore200310@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 20:40:13 -0400
In article <etAE1ZMtFHA.420@xxxxxxxxxxxxxxxxxxxx>, anonymous@xxxxxxxxxx
says...
>
> 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.
>
>
Why don't you share the code you have for one row and someone should be
able to generalize it.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
.
- Follow-Ups:
- References:
- Prev by Date: Re: Keeping excel visible
- Next by Date: RE: Copying Data
- Previous by thread: Need help writing Excel macro to solve a cell in each row of a spreadsheet
- Next by thread: Re: Need help writing Excel macro to solve a cell in each row of a spreadsheet
- Index(es):
Relevant Pages
|
