resetting Public variables

[tryer]

Is tere a way to reset all public variables in a module. I have a number of sub routines withing the same module and need to carry a variable from one to another so I have decalared tham as public variables.
This works fine except for an instance when I expect the variable to be empty (because nothing has yet been assigned to it) when in fact it contains the value that was assigned to last time another sub was run. So I suppose what I need is a way to reset all the variables in the module when a particular sub ends

[bhofsetz]

One way would be to re-assigning each variable to "" or empty either at the end of your sub or beginning of another.

If all your subroutines are in the same module then you don't need to declare your variables as Public. That is only necessary when using variables that are in different modules.

[Phil_V]

Another option would be to just pass the variable from one sub to the next when you need to. Like this:

Please Login or Register  to view this content.

[tryer]

Thank you guys,

bhofsetz, I didn't realise that variables values remained within the same module.

phil_V Again Thank you as I now know how to pass variable values to other sub routines