how do i find out which array range?

[kevinu]

Im using this code to set up arrays and then run a code called test to do stuff with the array. However, each array has a different range and the test code needs to adjust its code for each. I'm thinking of adding and if statement to determine which array the code is working with then adjust the start point in the test code.

I cant figure out how to find the array range. Unfortunately all the arrays are on one page so the name is the same its just the range thats different. How can i look for the range being used before the Next statement.

Please Login or Register  to view this content.

I was thinking of adding something like

Please Login or Register  to view this content.

but obviously thats the wrong way to find the range. In order to do this I believe ill have to make the test code a part of the array code... put it in just before the ending next statement.

[AlphaFrog]

Maybe something like this...

Please Login or Register  to view this content.