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 Setting variables to Nothing

integers can't be set to nothing. They are initialized to a value of zero.

You shouldn't have to worry about any type of local variable because they go
out of scope and are destroyed when the code in which they are defined stops
running.

No variables have a default value of Null, so you shouldn't use that.

Only objects can be set to Nothing

Dynamic arrays can be erased

--
Regards,
Tom Ogilvy


"Matt Jensen" wrote in message
...
As good programming practice, what of the possible variable types should

be
set to nothing or null?
Can /should you set integers to nothing for example?
Thanks
Matt