Clearing / Resetting Variables

I have a question regarding the resetting of variables at the end of a sub macro (Hoping that resetting is the correct description!).

For example :-

Code:

---

Set oRng = Nothing
    Set oFind = Nothing
    Set oCC = Nothing
    Set oDoc = Nothing
    Exit Sub
End Sub

---

Would I be correct in saying that it is best practice to do this for each variable that is declared at the start of a sub, or is this not the case and only certain ones need this?

Hi HTSFC Fareha. I'm going to vote for setting object and range variables to nothing and Erasing arrays. I'm guessing others have more to contribute. Dave

Thank you, Dave. This makes sense. Trying to reset anything that doesn't fall under either of these results in an error when running the macro in any case. :yes

Quote:

---

Originally Posted by HTSCF Fareha

I have a question regarding the resetting of variables at the end of a sub macro (Hoping that resetting is the correct description!).

Would I be correct in saying that it is best practice to do this for each variable that is declared at the start of a sub, or is this not the case and only certain ones need this?

---

I believe that the garbage collection kicks in at the End Sub/Function for any variables instantiated within the procedure, so I've been told that it's not necessary

HOWEVER ... I like to do it with those and some other constructs since the 'bracketing' helps me see things

Code:

---

Dim myObj as Class1

Set myObj = New Class1


...
...
...

Set myObject =Nothing

---

Personal style

Thanks for your input Paul. Much appreciated.

I think the consensus is to set them to nothing, that's good enough for me!