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...
 
Back
Top