UsedObjects object (Excel)

Represents objects that have been allocated in a workbook.

Example

Use the UsedObjects property of the Application object to return a UsedObjects collection.

After a UsedObjects collection is returned, you can determine the quantity of used objects in a Microsoft Excel application by 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

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.