Is there a way to cycle through the variables? Example below. Also when all the variables are cycled through, how to exit the loop?
![]()
Sub test() Dim var As String, var1 As String, var2 As String, var3 As String, var4 As String n = 1 var1 = "apple" var2 = "orange" var3 = "pear" Do Until ActiveCell.Value = var & n 'how would you do this part so the variable changes? ActiveCell.Offset(0, 1).Select Loop n = n + 1 end sub
Bookmarks