Hello Dear Excel Help
Is it somehow possible to define multiple variables with loop like follows?
Please Login or Register to view this content.
Hello Dear Excel Help
Is it somehow possible to define multiple variables with loop like follows?
Please Login or Register to view this content.
Last edited by jakopak; 10-29-2016 at 12:40 PM.
I am sorry, but your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Code Tags now added - thank you!
Last edited by AliGW; 10-29-2016 at 05:43 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I hope my post is correct now.
Thanks for adding the code tags.
To answer your question, in the OP code you defined the ar to be an array of strings. Every element of that array is a string.
That can't be changed.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
You can't declare variables like that.
Why don't you just use an array?
If posting code please use code tags, see here.
Nori, array will do. I just had a glimpse that it would simplify my code elsewhere. Perhaps it wouldn't. Anyway, I just like to have metaprogramming methods in my arsenal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks