PLEASE ALWAYS WRAP CODE
Hi,
I'm trying to assign a value to a variable within a for-next loop as i don't want to repeat the same code over and over again.
For n = 1 To 12
If "Break" + n + "End" = "" Then
"Break" & n & "End" = Counter1 + 13
End If
Next n
So, I have declared 12 variables as strings (ie: Break1End, Break2End, etc).
Is it possible to do something similar to the above? I can't seem to be able to find the right syntax to allow the vba editor in excel to accept the portion of code where I want to assign the value. Theoretically it makes sense to me but I am not sure.
I guess I don't have to simplify things using a loop but I would like to.
Thanks!
-A
Bookmarks