Excel.Application.MaxChange.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.MaxChange property (Excel)	vbaxl10.chm133162	vbaxl10.chm133162	Excel.Application.MaxChange	5620bdff-d006-8c85-a1b8-1e3b31f21092	04/05/2019	medium

Application.MaxChange property (Excel)

Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references. Read/write Double.

Syntax

expression.MaxChange

expression A variable that represents an Application object.

Remarks

The MaxIterations property sets the maximum number of iterations that Excel can use when resolving circular references.

Example

This example sets the maximum amount of change for each iteration to 0.1.

Application.MaxChange = 0.1

[!includeSupport and feedback]