Lifetime of variable

[tiredofit]

To clear an object variable, you would set it to nothing.

How would you clear a non-object variable?

I ask because in the following code, the variable a is declared at the module level, so every time the sub is run, the variable's value increases.

I want the variable a to "clear" after the sub that uses it has ended.

Option Explicit

Dim a As Integer

Sub Test()

    a = a + 1

End Sub

The reason it's declared at the module level, as opposed to the procedure level, is I have other subs that use the variable a later on (not shown here).

Thanks

 

[steve the fish]

Sounds like to me you want to Dim the variable in each sub not at the top of the module.

 

[RoryA]

The reason it's declared at the module level, as opposed to the procedure level, is I have other subs that use the variable a later on (not shown here).

If they aren't sharing the value of a, it shouldn't be a module level variable.

 

[tiredofit]

Thanks