Excel.Application.UsedObjects.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.UsedObjects property (Excel)	vbaxl10.chm133264	vbaxl10.chm133264	Excel.Application.UsedObjects	bf214478-990b-35c8-1e23-a9d1732e7ef3	04/05/2019	medium

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

[!includeSupport and feedback]