Set array of objects to nothing

  • Thread starter Thread starter Matthew Pfluger
  • Start date Start date
M

Matthew Pfluger

People have advised me to set object variables to nothing after they are no
longer needed:

Dim obj as Object
' do stuff
Set obj = Nothing

How do I set an array of objects to nothing?

Dim obj() as Object
ReDim obj(1 to Windows.Count)
' do stuff
' Set obj() = Nothing

Thanks,
Matthew Pfluger
 
You could loop through the array setting each item = Nothing or use 'Erase',
see help. They are not quite the same thing so use either method as
required.

If your array of objects is about to go out of scope it's not normally
necessary to explicitly release any object references it holds.

Regards,
Peter T
 
Very good. Thanks!

Peter T said:
You could loop through the array setting each item = Nothing or use 'Erase',
see help. They are not quite the same thing so use either method as
required.

If your array of objects is about to go out of scope it's not normally
necessary to explicitly release any object references it holds.

Regards,
Peter T
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple chart selection in Excel 2007 8
Run-time error for objects deletion 2
Adding controls to a userform at runtime 3
Excel process still shows in TaskManager 7
How to pass text to web page ? 4
Final space removed when moving to Object variable 6
Observing the Elements passed through an Expression of IQueryable<T> 7
IE Automation - checkbox 7

Back
Top