The below code works fine for 3 loops/runs but would like it to run for any given number. Ive done lots of searching on google but cant figure out how to implement a variable number in MyDay(3). the required number will be generated by the user via an input box. Could someone assist please
VBA Code:
Dim MyDay(3) As Variant
For i = 1 To UBound(MyDay)
'run my code here
MyDay(i) = 'outcome of code run
Next i