MaxIterations Property

Gets or sets the maximum number of calculation iterations.

[Visual Basic]
Overridable Property MaxIterations As Integer

[C#]
virtual int MaxIterations {get; set;}

[C++]
__property virtual int get_MaxIterations();
__property virtual void set_MaxIterations( 
   int value
);

[C++/CLI]
virtual property int MaxIterations {
   int get();
   void set (int value);
}

Remarks

When Iteration is true, formulas are calculated until the number of iterations equals MaxIterations or until the maximum change in any calculated cell is less than MaxChange.

Iteration is false by default

MaxChange is set to 0.001 by default.

MaxIterations is set to 100 by default.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbookSet Interface  | IWorkbookSet Members  | Iteration Property  | MaxChange Property

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.