LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default When to kill an object

Hi there,

I have a general question on what's best practise for killing redundant
objects.

For example, I've been using 'Set objRng = Nothing' at the end of various
procedures on the assumption that this clears them from memory.
So.............

a) Is that what happens?

b) Are variables/objects cleared when a workbook is closed, the application,
or on re-boot the whole PC!?

Thanks in advance

John


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to kill an ActiveX object Django Cat[_2_] Excel Discussion (Misc queries) 3 November 8th 07 07:45 PM
Kill Macro Jeff Excel Discussion (Misc queries) 4 September 27th 06 04:33 PM
Kill Michael Excel Programming 2 August 23rd 05 11:53 AM
'Kill' solomon_monkey Excel Programming 7 January 7th 05 09:56 AM
Kill variables Hari[_3_] Excel Programming 4 September 6th 04 08:57 PM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"