LinkBack URL
About LinkBacks
Question.
If I load an sheet into an array, lets say 1000 rows 20 columns, can I not then load individual items from that array into another array, let's say a 1 dimensional array?
Question.
If I load an sheet into an array, lets say 1000 rows 20 columns, can I not then load individual items from that array into another array, let's say a 1 dimensional array?
yes you can. have you had a problem with it?
Josie
if at first you don't succeed try doing it the way your wife told you to
Yes. I cannot figure out how to do this, keep getting error
I'd like to be able to load the entire array in one shot and then loop through that array for select items?
Can this be done, I have not been able to get this to work and have been told that I can only loop through both times, help and clarification?
Last edited by cmore; 10-10-2013 at 02:08 PM.
for instance
Please Login or Register to view this content.
Yeah, this is what I try and always get an error. I will try one more time and then post code. Maybe I've been just jacking things up.
What is the name of the error? Is it "Out script"?
I think I can't remember if it's the out of script or the 1004. I'll try soon and post just need to step away for a moment. I'm looking at your example and that's exactly what I write, except into 1-D arrays, so we shall see. I assume I'm doing something dumb.
cmore,
The code was written by Jay, not me.
Sorry about that, but yes I am getting the out of range error. I'm just trying to load a 1-D array. Code Below:
Please Login or Register to view this content.
An array that is loaded from a range will have lower bound of 1, rather than 0. Your code is failing trying to access column 0. You need to adjust your indices.
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Dagg, I knew it'd be something the opposite of smart. Thank You. How do I mark this SOLVED!
Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks