Hi! I thought for sure someone would have asked about this already, but I didn't have any luck searching the message board. I'd like to know if it's possible to simultaneously set all of my variables (or at least, my integer variables) to zero with a single line of code.
Right now I'm counting a number of things (each described by an integer variable) with a loop that exists within a bigger loop (bigger loop cycles through different worksheets). The little loop counts get reported to the active worksheet. I'd like all of my variables to re-set to zero before starting my little loop again on the next worksheet. The variables are named after what they describe, so their names are unique. I'd like to keep it this way, though I know if I just turned them into an array I could easily clear the values. Right now I have a looooong list of variables getting set to zero (var1=0, var2=0...var3847583=0...YUCK).
Is there a way to do what I'd like here? Thank you!!
Right now I'm counting a number of things (each described by an integer variable) with a loop that exists within a bigger loop (bigger loop cycles through different worksheets). The little loop counts get reported to the active worksheet. I'd like all of my variables to re-set to zero before starting my little loop again on the next worksheet. The variables are named after what they describe, so their names are unique. I'd like to keep it this way, though I know if I just turned them into an array I could easily clear the values. Right now I have a looooong list of variables getting set to zero (var1=0, var2=0...var3847583=0...YUCK).
Is there a way to do what I'd like here? Thank you!!
