This is probably something very basic, but I dunno how it's done as I've never ran into this problem before....

When you have a project with a LARGE number of integer variables declared as public and you want to set them all to zero each time the sub is run. Is there some simple way of doing this like "Put all variables of type_integer = 0" instead of listing them all as: a=0: b=0: c=0: d=0: e=0: f=0: g=0: h=0:....and so on ad infinitum?

I know you could maybe do something like have integer variables with names like a1, a2, a3, a4, a5, a6,...etc and set them to zero by running a for_to_next loop at the start of the sub (e.g. something like For N = 1 to 100 a & N = 0 Next N) but not when they're "descriptive" type names...

TIA