Application.UsedObjects Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub CountUsedObjects()

MsgBox "The number of used objects in this application is: " & _
    Application.<strong class="bterm">UsedObjects</strong>.Count



End Sub

See Also