Skip to content

Latest commit

 

History

History
42 lines (24 loc) · 955 Bytes

Excel.Application.MaxIterations.md

File metadata and controls

42 lines (24 loc) · 955 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.MaxIterations property (Excel)
vbaxl10.chm133163
vbaxl10.chm133163
Excel.Application.MaxIterations
83f12597-9186-e415-a22b-9e028bd95169
04/05/2019
medium

Application.MaxIterations property (Excel)

Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference. Read/write Long.

Syntax

expression.MaxIterations

expression A variable that represents an Application object.

Remarks

The MaxChange property sets the maximum amount of change between each iteration when Excel is resolving circular references.

Example

This example sets the maximum number of iterations at 1000.

Application.MaxIterations = 1000

[!includeSupport and feedback]