How to Set an Integer to Nothing

[orcinus]

Would like to know if its possible to set an integer type variable to nothing. If not, then in order to free up the memory and rid that variable of any values it might currently have, how do I do this?

Note: I tried:

int_var = nothing

Set int_var = nothing

to no avail.

I did think of setting it to zero (0) but was then thinking that the variable still holds a value even it the value is zero?

Thanks for any help with conceptual and syntax help on this..

[ajetrumpet]

sir,

if you want the truth, unless you have a 1GB size or bigger db, this is not really even important from a memory-saving prospective.

Not IMO, anyway. What is your reasoning for this?

[orcinus]

sir,

if you want the truth, unless you have a 1GB size or bigger db, this is not really even important from a memory-saving prospective.

Not IMO, anyway. What is your reasoning for this?

I've heard that it good to reset variables so that when they have completed their raison d'etre for any given session, it is good to set their values to be nothing, or empty.

However, what I'm not clear on the scope of the variables this applies to. What I've seen is that people almost always set a variable to 'nothing' that is (I believe) an object(?) variable. So when a recordset has completed its programming mission (for a given run), in the code, they set this variable back to nothing or empty(?)

Though, again, I'm not sure the scope. So, does this reasoning apply to string variables? Integer variables? etc..And if it does, does each variable or set of variables have its own "nothing" setting that you set it back to after its completed its purpose?

So, thinking about this some more, maybe upon completing their function, these variables need to reset to their value they had upon being Dim'd?

So, I checked the String and Integer variables after being Dim'd but before any value is assigned and the String variable shows "" and the Integer value shows 0.

Is this the answer to my question? It seems so..

Thanks..

[ajetrumpet]

OK...I only read the first 2 sentences of your last post. So for that, check this out: http://www.mrexcel.com/forum/showthread.php?t=14195

what he's saying is true. numbers reset to 0. you cannot empty them or set them, to my knowledge anyway.

but again you're back to the purpose of why you're doing it. for instance, if you're getting a project done quickly, this should be of little concern. It usually is to me anyway, as most customers want things quickly.

as far as the standard for doing this sort of stuff, see the last line of the above post. also, check out: www.cpearson.com

Chip Pearson discusses this stuff somewhere on his site. He's an extremely intelligent person, but a lot of his stuff is advanced, so if you're somewhat of a novice, the site's content may be confusing at times.

[orcinus]

OK...I only read the first 2 sentences of your last post. So for that, check this out: http://www.mrexcel.com/forum/showthread.php?t=14195

what he's saying is true. numbers reset to 0. you cannot empty them or set them, to my knowledge anyway.

but again you're back to the purpose of why you're doing it. for instance, if you're getting a project done quickly, this should be of little concern. It usually is to me anyway, as most customers want things quickly.

as far as the standard for doing this sort of stuff, see the last line of the above post. also, check out: www.cpearson.com

Chip Pearson discusses this stuff somewhere on his site. He's an extremely intelligent person, but a lot of his stuff is advanced, so if you're somewhat of a novice, the site's content may be confusing at times.

I'm a "variable frequency" user. Some stuff I know is fairly advanced, other more simple stuff I don't know. Characteristic of being self taught and not starting from any particular "beginning".

So for me its hit and miss..but after reading this, I'm a bit more 'hit' on this particular subject..

Thanks for the links and thoughts..