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
