Excel.UsedObjects.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
UsedObjects object (Excel)	vbaxl10.chm677072	vbaxl10.chm677072	Excel.UsedObjects	b94ad3d1-411f-acf6-19bb-8e6c4a484748	04/03/2019	medium

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

[!includeSupport and feedback]