| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Releasing arrays?
Hi, when using arrays in a VBA sub, is it necessary to explict release memory at the end of procedure? If so, how to do this? I have tried Set myArr = nothing but it did not work. Thank you, Siri -- SiriS ------------------------------------------------------------------------ SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995 View this thread: http://www.excelforum.com/showthread...hreadid=494563 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Releasing arrays?
Hi SiriS,
If so, how to do this? I have tried Set myArr = nothing but it did not work. Try: Erase myAyy --- Regards, Norman "SiriS" wrote in message ... Hi, when using arrays in a VBA sub, is it necessary to explict release memory at the end of procedure? If so, how to do this? I have tried Set myArr = nothing but it did not work. Thank you, Siri -- SiriS ------------------------------------------------------------------------ SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995 View this thread: http://www.excelforum.com/showthread...hreadid=494563 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Releasing arrays?
Erase myAyy
Or even: Erase myArr --- Regards, Norman "Norman Jones" wrote in message ... Hi SiriS, If so, how to do this? I have tried Set myArr = nothing but it did not work. Try: Erase myAyy --- Regards, Norman "SiriS" wrote in message ... Hi, when using arrays in a VBA sub, is it necessary to explict release memory at the end of procedure? If so, how to do this? I have tried Set myArr = nothing but it did not work. Thank you, Siri -- SiriS ------------------------------------------------------------------------ SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995 View this thread: http://www.excelforum.com/showthread...hreadid=494563 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Releasing arrays?
Hi, Thank you, the Erase fucntion is just what I need! Siri -- SiriS ------------------------------------------------------------------------ SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995 View this thread: http://www.excelforum.com/showthread...hreadid=494563 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
| vba adding arrays | Excel Discussion (Misc queries) | |||
| Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| Comparing Arrays | Excel Discussion (Misc queries) | |||
Linear Mode
