Application.UsedObjects Property

Syntax

expression.UsedObjects

expression A variable that represents an Application object.

Example

In this example, Microsoft Excel determines the quantity of objects that have been allocated and notifies the user. This example assumes a recalculation was performed in the application and was interrupted before finishing.

Sub CountUsedObjects() MsgBox "The number of used objects in this application is: " & _ Application.UsedObjects.Count End Sub

See also:

• Application Object
• Application Object Members