Set Variable or object Nothing

Hi,

Normally, if we use ws As worksheet or wb As workbook, at the bottom of code, we will write Set ws =Nothing / Set wb =Nothing


How about if we use rng = Worksheets("ORIGINATOR").Range("B" & j & ":B" & i), Do we need to write Set rng =Nothing?

then, I'm just want to know what is the important of set variable to "nothing"

You do not need; it is a good programming practice releasing the memory on object variables once the code has been executed.

Hi AB33,

So, does it means that the set variable to "Nothing" only applicable to Object but the range is NOT required ?.

Any impact to VBA code which lead to run-time error / any errors ?

Object variable and arrays can be erased. Range could be an object variable. It does not mean a lot, you are emptying the variable, that is all.
It can lead to an error if you release the object, but trying to refer it again on any code or part of the code, hence you see it at the bottom of a code.

Thanks for a good explanation.