• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

G. New Objects in Excel XP > UsedObjects Object

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

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint