New UsedObjects Property in Excel XP
 

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?

New UsedObjects Property in Excel XP
 

try a
DIM oThisObject as Object
For Each oThisObject In Application.UsedObjects
and take a look at oThisObject in the locals or watch window.


--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
"Ian Ripsher" wrote in message
...
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?