David Thanks for the reply. I am now thinking that it is not possible. I have though of a few possible variations that might work, but they are not ideal and will need testing.
Bob On Jun 23, 8:22 pm, who <dlanm...@att.net> wrote: > Hi Bob, > > I think it will be difficult to stop Solver, once it starts its > iterations. The people that may best be able to help you would be one > of the old time MVPs, although the Microsoft site is now shut down and > I do not know how you would go about getting in touch with one of them > now. > > Good luck, I will keep an eye on this one. > > I thought some of the old timers were hanging around here, but maybe > not. > > Thanks, > David > > On Jun 22, 3:41 pm, RBachman <robert.c.bach...@gmail.com> wrote: > > > I have successfully been programming with the solver for years and am > > very familar with it. I typically use it to solve a non-linear > > equation at one point in time and then advance the solution in time. > > In this approach one has a cell given by a formula that one is > > typically driving down to zero by changing a particular variable or > > group of variables. At the next timestep one repeats on the next line > > of the worksheet. > > > This is a very typical process for obtaining engineering solutions to > > problems. This can be inefficient due to the large number of > > recalculation events generated when using Excel formula in association > > with user defined functions (even when the Application.Calculation > > switch is flipped from automatic to manual and back to automatic > > within VBA). The long solution times are evident at later timesteps, > > when lots of the previous lines are being recalculated > > unnecessarily. > > > To improve the speed of this process I would like to do the following. > > Instead of the target cell being a formula it would be a result > > (value) of a potentially complex calculation performed by a macro. > > Even better, could the value being driven to zero be a local variable > > within the VBA module. Now the cells to be modified would be standard > > input cells (or even better just local variables in the VBA module). > > If somehow within solver iteration the macro was callable within its > > iterative loop I would have a very powerful and fast non-linear > > solver, with minimal interaction with the worksheet. This would be a > > very fast calculation. > > > Is this possible? > > > Bob -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
