Public strings keeping values after a macro is completed

Hello everyone!

I am having issues with a few of my public variables that are keeping the values of that were stored in them in the last run (Excel wasn't closed).

How do I reset the values, without having to do s_Test1 = "" for each string?

Here is an example, If I run this macro two times, it keeps the values form the first run and shows x2 values in the second run:

Please Login or Register  to view this content.

Why not declare them in the sub?

Originally Posted by Kyle123

Why not declare them in the sub?

The reason I am not declaring them within a sub is that I have multiple subs where I am using these values.

Then either pass them as parameters or clear the values at the end of the sub