Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
Application Object
Properties
ActiveCell Property
ActiveChart Property
ActiveEncryptionSession Property
ActivePrinter Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
AddIns Property
AlertBeforeOverwriting Property
AltStartupPath Property
AlwaysUseClearType Property
AnswerWizard Property
Application Property
ArbitraryXMLSupportAvailable Property
AskToUpdateLinks Property
Assistance Property
Assistant Property
AutoCorrect Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
Build Property
CalculateBeforeSave Property
Calculation Property
CalculationInterruptKey Property
CalculationState Property
CalculationVersion Property
Caller Property
CanPlaySounds Property
CanRecordSounds Property
Caption Property
CellDragAndDrop Property
Cells Property
Charts Property
ClipboardFormats Property
Columns Property
COMAddIns Property
CommandBars Property
CommandUnderlines Property
ConstrainNumeric Property
ControlCharacters Property
CopyObjectsWithCells Property
Creator Property
Cursor Property
CursorMovement Property
CustomListCount Property
CutCopyMode Property
DataEntryMode Property
DDEAppReturnCode Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultWebOptions Property
DeferAsyncQueries Property
Dialogs Property
DisplayAlerts Property
DisplayClipboardWindow Property
DisplayCommentIndicator Property
DisplayDocumentActionTaskPane Property
DisplayDocumentInformationPanel Property
DisplayExcel4Menus Property
DisplayFormulaAutoComplete Property
DisplayFormulaBar Property
DisplayFullScreen Property
DisplayFunctionToolTips Property
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayScrollBars Property
DisplayStatusBar Property
EditDirectlyInCell Property
EnableAnimations Property
EnableAsyncQueriesInIdle Property
EnableAutoComplete Property
EnableCancelKey Property
EnableEvents Property
EnableLargeOperationAlert Property
EnableLivePreview Property
EnableSound Property
ErrorCheckingOptions Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExtendList Property
FeatureInstall Property
FileConverters Property
FileDialog Property
FileExportConverters Property
FileFind Property
FindFormat Property
FixedDecimal Property
FixedDecimalPlaces Property
FormulaBarHeight Property
GenerateGetPivotData Property
GenerateTableRefs Property
Height Property
Hinstance Property
Hwnd Property
IgnoreRemoteRequests Property
Interactive Property
International Property
Iteration Property
LanguageSettings Property
LargeOperationCellThousandCount Property
Left Property
LibraryPath Property
MailSession Property
MailSystem Property
MapPaperSize Property
MathCoprocessorAvailable Property
MaxChange Property
MaxIterations Property
MeasurementUnit Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Property
MultiThreadedCalculation Property
Name Property
Names Property
NetworkTemplatesPath Property
NewWorkbook Property
ODBCErrors Property
ODBCTimeout Property
OLEDBErrors Property
OnWindow Property
OperatingSystem Property
OrganizationName Property
Parent Property
Path Property
PathSeparator Property
PivotTableSelection Property
PreviousSelections Property
ProductCode Property
PromptForSummaryInfo Property
Range Property
Ready Property
RecentFiles Property
RecordRelative Property
ReferenceStyle Property
RegisteredFunctions Property
ReplaceFormat Property
RollZoom Property
Rows Property
RTD Property
ScreenUpdating Property
Selection Property
Sheets Property
SheetsInNewWorkbook Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowDevTools Property
ShowMenuFloaties Property
ShowSelectionFloaties Property
ShowStartupDialog Property
ShowToolTips Property
ShowWindowsInTaskbar Property
SmartTagRecognizers Property
Speech Property
SpellingOptions Property
StandardFont Property
StandardFontSize Property
StartupPath Property
StatusBar Property
TemplatesPath Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
Top Property
TransitionMenuKey Property
TransitionMenuKeyAction Property
TransitionNavigKeys Property
UsableHeight Property
UsableWidth Property
UsedObjects Property
UseLegacyKeyboardShortcuts Property
UserControl Property
UserLibraryPath Property
UserName Property
UseSystemSeparators Property
Value Property
VBE Property
Version Property
Visible Property
WarnOnFunctionNameConflict Property
Watches Property
Width Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
WorksheetFunction Property
Worksheets Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Application.Iteration Property

Office 2007
True if Microsoft Excel will use iteration to resolve circular references. Read/write Boolean.

Syntax

expression.Iteration

expression   A variable that represents an Application object.

Example

This example sets the Iteration property to True so that circular references will be resolved by iteration.

Visual Basic for Applications
Application.Iteration = True

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.