Results 1 to 4 of 4

Garbage Collection using VBA

Threaded View

mms Garbage Collection using VBA 04-18-2019, 08:45 AM
CK76 Re: Garbage Collection using... 04-18-2019, 08:54 AM
BadlySpelledBuoy Re: Garbage Collection using... 04-18-2019, 09:11 AM
mms Re: Garbage Collection using... 04-18-2019, 09:54 AM
  1. #1
    Registered User
    Join Date
    11-16-2004
    Posts
    38

    Garbage Collection using VBA

    Hello,

    In some programming languages I use, garbage collection is taken care of automatically by the program,
    in others, the programmer is responsible for this.

    With Excel VBA, which is the case?

    ie if I do the following:
    Dim ws1 As Worksheet
    Dim ws2 As Worksheet
    Set ws1 = Sheets("Calculator Data Table")
    Set ws2 = Sheets("W-Shape MC")

    Must I do the following when I am finished with them?
    Set ws1 = Nothing
    Set ws2 = Nothing


    Similarly with:
    Dim MyRange
    MyRange = "A1:" & Selection.SpecialCells(xlCellTypeLastCell).Address

    Is the following required?
    Set MyRange = Nothing
    Last edited by mms; 04-18-2019 at 08:48 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] When a collection created bring another column value into the collection
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2018, 04:33 AM
  2. [SOLVED] Issue - Garbage on my screen
    By kev_ in forum Suggestions for Improvement
    Replies: 13
    Last Post: 02-23-2017, 03:26 PM
  3. Replies: 4
    Last Post: 10-30-2015, 01:30 PM
  4. [SOLVED] Performance of iteration through Words collection degrades as collection gets bigger
    By 6StringJazzer in forum Word Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2014, 09:44 AM
  5. Replies: 2
    Last Post: 12-23-2011, 11:04 AM
  6. Garbage collection in VBA
    By Edward Ulle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2005, 02:00 PM
  7. Deleting garbage
    By Sandra in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-05-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1