Hey everyone,
What I’d like to know is is it possible to do a variable for loop where you can tell it to do the loop so many times. For example I am doing this to keep track of my team stats but the number of people on my team is variable and changes on a irregular basis and so it is difficult to constantly have to remove or add people here and then modify my macro to fit my new team size
Sub test ()
Dim a as integer, I as integer
a = range(“b2”)
For i = 1 to a
Activecell.value = inputbox(“how many surveys?”)
Activecell.offset(1,0).activate
Next i
Bookmarks