change variable on every iteration in loop

**JJGF** · 10-11-2015, 10:18 AM

Is there a way to cycle through the variables? Example below. Also when all the variables are cycled through, how to exit the loop?

Please Login or Register  to view this content.

**MrShorty** · 10-11-2015, 10:50 AM

Instead of individual variables, use an array:

Please Login or Register  to view this content.

https://msdn.microsoft.com/en-us/library/wak0wfyt.aspx or put "using arrays in VBA" into your favorite internet search engine.

**JJGF** · 10-12-2015, 10:00 PM

works, thanks.

Re: change variable on every iteration in loop