View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default Numerical integration to a maximum value using VBA

Hi John,

You can tell the VBA debugger to stop when a variable will be given a
certain value.

You can estimate this value and enter it or you can store its old value
(of previous iteration), subtract this from the newer one and stop the
program if the difference becomes < zero (if your iteration is
monotonously increasing).

HTH,
Bernd