UsedObjects Object
Collapse the table of content
Expand the table of content

UsedObjects Object

Office 2007
Represents objects that have been allocated in a workbook.


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

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.

Visual Basic for Applications
Sub CountUsedObjects()

    MsgBox "The number of used objects in this application is: " & _

End Sub

© 2016 Microsoft