VBA usedobjects set usage

After returning a usedobjects set, you can use the Count attribute to determine the Microsoft Excel application. ProgramNumber of objects used in.
In this example, Microsoft Excel determines the number of allocated objects and notifies the user. This example assumes that the re-calculation is performed in the application and the re-calculation is interrupted before the re-calculation is completed. CopyCodeThe Code is as follows: Sub countusedobjects ()
Msgbox "the number of used objects in this application is :"&_
Application. usedobjects. Count
End sub