Reading two data points at a time in Excel

[mtcellar65]

I would like some help on a programming issue:

I know how to read whole excel data sets but how do you read two points at a time?  I would like to extract a number from row 1 column 1 and row 1 column 2.  I will use these numbers simultaneously as for loop counters.  Then the program should read row 2 column 1 and row 2 column 2.  This pattern should continue (number of times unknown) until the two numbers both equal 0.

Please help me with any suggestions you have.

Thanks ahead of time!

[RENN]

Hi mtcellar65

1. you know how to read the whole excel data -  just read the 2D Array (whole information)

2. extract the single elements using 'Index Array' Function.

 the index for row and column can be kept in a shift register.

3. increment the indices and repeat step 2 again

hope this helps

Renn