View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Set variable = nothing?

If it is a local variable and the routine ends, it is cleaned up anyway
because it goes out of scope. So it isn't necessary/essential.

--
Regards,
Tom Ogilvy

"raj" wrote in message
...
Just a quick verification...

If one were to use the following code line:

Set xFind = Range(xColumn).Find("Total Equities")

Or for that matter, anytime the "Set" command is used,
shouldn't one always at some point later set the variable
equal to nothing?

For example,

Set xFind = Nothing

Thanks for your input.