How do you destroy a variable?

[phantom1975]

Once I have a variable set within a procedure, how can I destroy the value of the variable within the procedure? I'm not sure, but I thought it was something like:

MyVar = Nothing

_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-09-17 20:08

 

[white6174]

THAT SHOULD WORK


OR
MyVar =0


OR
MyVar ="" (NOT SURE)

STEVE W
This message was edited by white6174 on 2002-09-17 20:17

 

[phantom1975]

I'm afraid that 0 and "" still are values. Zero is an integer and "" is a string.

 

[white6174]

I believe that when a variable is nothing it is seen as zero in a calculation.

steve w

 

[Hero-0952]

Hey Phantom,

I pasted the wrong link...BRB.

Ok, I found the link. There are several references here to the MyVar= :
http://www.provider.com.br/infobahia/101tips_7.htm

I was also looking at another thread on another board that seems to agree with what you said Phantom; that even a 0 is a value:

http://www.experts-exchange.com/Applications/MS_Office/Q_11706499.html

Regards,

ViperGTS

________________
This message was edited by ViperGTS on 2002-09-17 21:05

 

[Jay Petrulis]

Hi,

I believe that white6174 is correct. It depends on the declaration of your variable.

Set objects to nothing (possibly .Delete may work, too).
For numerics, you can set them to zero.
For strings, you can set them to "".

For the non-objects, you can also set them to Empty to give them their default variables

x = Empty

will set x back to its default.

I don't believe that you can actually destroy variables unless you use the following statement in your code

End

although that deletes a whole bunch and ends your routine.

In general, once initialized the variable is created and stays that way until the procedure is out of scope. Possibly others know a way to explicitly destroy a variable, but I do not.

 

[phantom1975]

AWESOME link Viper! I copied it to a Word document and it's 82 pages long. Looks like I have some bathroom reading for a few weeks.