UsedObjects Object (Excel)
Represents objects that have been allocated in a workbook.
Once a UsedObjects collection is returned, you can determine the quantity of used objects in a Microsoft Excel application using the Count property.
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