Hello,
I have been trying to create an array of array or jagged array. I can't get it to work despite looking on the web for solutions.
As an example this is what I'm trying to do:
var_Project var_Name
Project 1- John Peter
Project 2 - Peter
Project 3 - Sarah Peter John
Then I would like to recall
var_Project(1)(1)=John
var_Project(2)(1)=Peter
var_Project(3)(2)=Peter
How would I write this in vba code.
Thank you in advance for anyone who helps.
I am curious what your research turned up that you found difficult to understand. I would expect something like this?Note that I can control the lower limit for the outer varproject() array, but the inner "variants containing arrays" will default to a 0 based array, which is why I used 0 as the index for the first element of each inner array.
Please Login or Register to view this content.
Originally Posted by shg
Very nice. They are a couple of links that address the problem. I'm unable to post the links since I'm new to the board.
I tried to post the question as simple as possible to get a better understanding of the basics and you did just that, explained it in a very easy way for me to understand. I really appreciate it.
Thanks.
Hello
This may help you .. I suppose you have two columns of data A & B ..
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
As wanted lol...just to be playful
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Another option !!!
Data start "A1":- NB:- Project and names split into columns/rows as below
var_Project var_Name
Project 1 John Peter
Project 2 Peter
Project 3 Sarah Peter John
Result start "K11"
Regards MickPlease Login or Register to view this content.
Last edited by MickG; 07-12-2018 at 01:07 PM.
How about using a dictionary?
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks