New UsedObjects Property in Excel XP

  • Thread starter Thread starter Ian Ripsher
  • Start date Start date
I

Ian Ripsher

I've been looking at this object in Excel 2003, which I believe was
introduced in Excel XP. The MS documentation is scant, to say the least:
"Returns a UsedObjects object representing objects allocated in a workbook."

It then gives an example of its use:

Sub CountUsedObjects()

MsgBox "The number of used objects in this application is: " & _
Application.UsedObjects.Count

End Sub


If you run the above sub in a new, blank, 3-worksheet workbook, the count
property returns 7.

Has anyone deciphered exactly what this object does/means/can be usefully
used for?
 
try a
DIM oThisObject as Object
For Each oThisObject In Application.UsedObjects
and take a look at oThisObject in the locals or watch window.
 
Back
Top