Clearing object variables

[tiredofit]

Is it good practice to clear an object variable before using it?

For example:

Option Explicit
Sub ClearingObjects()

    Dim ws As Worksheet
    
    Set ws = Worksheets("Sheet1")
    
    ws.Cells(1, 1).Value = 1
    
        Set ws = Nothing
    
    Set ws = Worksheets("Sheet2")
    
    ws.Cells(1, 1).Value = 2
    
    Set ws = Nothing

End Sub

is this line good practice?

Set ws = Nothing

Thanks

 

[steve the fish]

In this case it would make no difference.

 

[tiredofit]

In this case it would make no difference.

Can you give me an example when you must clear the variable before using it again?

 

[steve the fish]

It may cause problems if you were setting the variable to an application using New for example. Your variables above would be destroyed when the procedure completed.

 

[tiredofit]

I see, thanks.

 

[Kyle123]

99 times out of 100 it's a complete waste of space

The only time I can think of that it's really necessary is when you make circular references that confuse the GC. It's required then to prevent memory leaks, but this type of thing is pretty rare.