I have a number of variables being declared as "Public" so that their values hold through a number of sub procedures. For one, I need a few of the values to change. Originally I thought I could do the following:
Start_Row = 3
Call ShadeRow
Start_Row = 5
Call ShadeRow2
Basically, setting the value of Start_Row to 3, calling ShadeRow, then resetting the value of Start_Row to 5 and calling ShadeRow2.
Is there a way to accomplish this? I'm trying to limit the amount of variables that exist for easier editing/flexibility.
Start_Row = 3
Call ShadeRow
Start_Row = 5
Call ShadeRow2
Basically, setting the value of Start_Row to 3, calling ShadeRow, then resetting the value of Start_Row to 5 and calling ShadeRow2.
Is there a way to accomplish this? I'm trying to limit the amount of variables that exist for easier editing/flexibility.