Cory Posted February 5, 2009 Report Share Posted February 5, 2009 I have been using multiple array variables as tables of data but I've had a questing in the back of my mind that hasn't been important until now. The problem is how many elements do I define when I don't know how many 'rows' of data I will have. Up until now I've know my tables would be less than 999 so I would just use that but now I'm writing a macro that might eventually have very large and as of now unknown data sets. Now I checked it out and found that I can create as many as 2,147,483,647 (2^32/2-1) elements which will for sure be way more than enough but would there be a drawback if I used this value? I can use a smaller value if so but if it's important not to have too large a value I will make this as close as possible but now I will need to add some test to make sure before hand the set its not to large. The other related question is if there is a way to somehow set the array elements dynamically. Thoughts? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.