Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "Matthew Pfluger" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Very good. Thanks!
"Peter T" wrote: 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 "Matthew Pfluger" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2002 - Select All Objects in an Array... | Excel Programming | |||
Test for end of array of objects? | Excel Programming | |||
Trying To Store Shapes/Objects to an array ?? | Excel Programming | |||
Trying To Store Shapes/Objects to an array ?? | Excel Programming | |||
How can you make an array of objects? | Excel Programming |