Application.UsedObjects Property (Excel)
Returns a UsedObjects object representing objects allocated in a workbook. Read-only
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