How to set a variable in combination with a looping x counter

[herbie226]

Hello,

I am trying to set a variable in combination with a looping x counter, so that as the loop continues a new variable is set for a given range.

Please Login or Register  to view this content.

Any help with performing this action would be most appreciated!

Thanks,

Jason

[dageci]

Don't know if this is what you want:

Please Login or Register  to view this content.

[herbie226]

No, because A_Variable will always be reassigned for each loop. I need the variable to be a distinct variable for each loop.

Appreciate the help.

[dageci]

Well then you need a dynamic array variable

Something like this:

Please Login or Register  to view this content.

[herbie226]

Brilliant! Thank you so much!!!

[dageci]

Maybe you can help me now. To register on my webpage www.virtual-forms.com and become a beta tester of new concept of Excel Userforms and if you love it, maybe tell some friends about it :-)

Davor