Writing Excel Macros with VBA, 2nd Edition

Name

UsedObjects Object

Synopsis

Path: Application - UsedObjects

Object	Properties
UsedObjects	Count( ) As Long Item(Index As Variant) As Object

The documentation for the UsedObjects collection object is incredibly bad, even by Microsoft standards, which is saying a lot. It gives absolutely no clue as to what used objects might be, but it does tell us how to count the number of used objects!

If you open a brand new workbook (with the default three empty worksheets), then the code:

Application.UsedObjects.Count

returns the number 7, so whatever is used object might be, there are 7 of them in a new workbook.

After some experimentation and much frustration, I conclude that if Microsoft does not consider it worth spending time to write even a sentence explaining used objects, then it is probably not worth your time or mine to try to figure it out.