Hi thanks for looking,
please could you help me with the syntax
I'm not sure how to reference the array object to use it as a variable with 'i'?Please Login or Register to view this content.
Thanks for your help
Hi thanks for looking,
please could you help me with the syntax
I'm not sure how to reference the array object to use it as a variable with 'i'?Please Login or Register to view this content.
Thanks for your help
In the absence of any more information, I *think* you want:
Please Login or Register to view this content.
Are you saying you have multiple arrays? Like Array1, Array2, etc.
That's what it sounds like, but if so, your code is nonsensical because you have to set a position in an array equal to something. You can't set an array equal to a range.
However, assuming you have one array (let's call it Array1), and that array contains 6 positions, then:
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Hi Thanks Kyle. Sorry I posted this in a bit of a rush,
What I am after, is the ability to concatenate an 'array name' -I have no idea if this is even possible!
I have -I am trying to create a loop which delegates variables to each array, rather than assign the variables individually to each array.Please Login or Register to view this content.
With the below
It is filtering my data (representing countries entered by humans - so its variables, now delegated as a number)Please Login or Register to view this content.
country 1, I am trying to assign to ArrayV1 < with the 1 assigned by 'i'.
What I need to find is something like Array("ArrayV" & 1) = RNG
I am not sure how to fully qualify an 'array' or if it belongs to an object group that I could use to concatenate the name?
Thankyou!
Thankyou walruseggman, Yes I will need to change that to
and remove the fRNGPlease Login or Register to view this content.
I believe leaving as array as 'myarray()' gives a dynamic property and fits to the size rqd
Last edited by graym463; 11-23-2015 at 11:19 AM.
As a guess, it looks to me like you are wanting to learn the concept of "jagged arrays" that I am also learning: http://www.excelforum.com/excel-prog...-practice.html
Originally Posted by shg
I don't think your code does what you think it does and I'd restructure what you're trying to do, but I digress. You can't do that, I think you want to use a single dictionary object, where each element is what you currently have as an array - you can then reference it by key. Something like:
Please Login or Register to view this content.
Thankyou Kyle123, I will look into scripting.dictionary I have not yet used this
Thanks MrShorty - I have used Jagged Arrays, this is what I needed! I believe I have interpreted that idea in the below code - it seems to be working
Please Login or Register to view this content.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks