Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference in VBA to "Maximum change" Value ??
Hello;
Following an iteration procedure (e.g.; using GoalSeek or Solver in a standard macro), it makes sense to avoid equal or zero comparisons or to introduce a new error tolerance. For example, if the iteration result from the procedure is res1 within the "Maximum change" value set at (tol1=) 1.E-6 (or whatever), and I need to compare res1 with an analytical value val1 using the same tol1: (Excel 2003 SP3, Windows XP) ' tol1 = Maximum change value set under Options IF abs( res1 - val1) tol1 then '.... do something EndIF How do I extract the value of (or make reference to) the "Maximum change" value tol ?? Thank you kindly. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference in VBA to "Maximum change" Value ??
Hi;
This works fine: tol1 = Application.MaxChange IF abs( res1 - val1) tol1 Then '.... do something EndIF It couldn't be simpler! Sorry, but I don't have a clue why it didn't work earlier! Regards. "monir" wrote: Hello; Following an iteration procedure (e.g.; using GoalSeek or Solver in a standard macro), it makes sense to avoid equal or zero comparisons or to introduce a new error tolerance. For example, if the iteration result from the procedure is res1 within the "Maximum change" value set at (tol1=) 1.E-6 (or whatever), and I need to compare res1 with an analytical value val1 using the same tol1: (Excel 2003 SP3, Windows XP) ' tol1 = Maximum change value set under Options IF abs( res1 - val1) tol1 then '.... do something EndIF How do I extract the value of (or make reference to) the "Maximum change" value tol ?? Thank you kindly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
xy plot line style change when I select "fixed maximum" | Charts and Charting in Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
can i change "A" to "Name" in reference to columns | Excel Discussion (Misc queries) | |||
Object hyperlink produces "Reference is not valid" error after worksheet name change | Excel Programming |