Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • Thank you for clearing this up. I kept seeing it and was beginning to wonder if I was making a newbie mistake by not doing so. All instances of Set Nothing have been removed! Commented Jun 27, 2018 at 15:44
  • So how does this fit with IE instances for example grinding a PC to a halt even though out of scope when coders haven't quit the application. Is this a distinction on a process over an object? Commented Jun 27, 2018 at 16:01
  • 7
    @QHarr I don't do IE stuff in VBA, but if I did, I'd probably enclose the instance in a With block, e.g. With New InternetExplorer or whatever the class name is: when the With blocks owns the instance, the object dies when End With is reached. Commented Jun 27, 2018 at 16:03
  • 2
    That's a really nice note on the With blocks Commented Jan 18, 2019 at 19:45
  • 1
    @urdearboy interesting one! I've commented =) Commented Aug 3, 2022 at 22:02