I know this has to be simple to most, but Loops are new to me.
I have some lines of code that need to run a number of times. The number of times it needs to run is the total of how many territories, regions and districts we have. I have that number calculated and populating cell AA1, currently as 117 total. So this code needs to run 117 times. I have tried:
When I try to change the Loop Until MyNum = from 117 to AA1. I don't understand how to make MyNum reflect the value in cell AA1 I guess. Or should I be using a different method. I found this in the help file as using a Loop until condition becomes true method.