I want to transfer to a variable name the row number on which a look up value is found. Example, a specified contract number is looked up in a Excel contract file using a VBA lookup routine and was found on Row 50 of the file spreadsheet. How do I grab this number?

Thanks for the tip and the example of transpose.

<t>Thanks. I have read something in the past about transposing arrays but have not been able to find the source again. I thought there was a transpose instruction in VBA but haven't been able to find it. Ultimately, I solved my problem by resizing a two column array with an indefinite number of rows...

I sure do. I think they're home base is somewhere in the northeastern US

<t>Well, after much internet searching and re-reading my text on multi-dimensional array syntax for the 100th time, I discovered an example of the ReDim Preserve statement in a static array in which ArrayName(3, 8) could be resized (via ReDim) to ArrayName(3, 15) but not to ArrayName(5, 8) because o...

Thanks for the comment. I have never used collections before. Will have to read up on them.BigBill

<t>Dominic:Thanks for your helpful reply. I'm using Excel 2000 9.0.The application fragment I'm writing involves processing credit invoices in an accounting system. Out of 100 transactions in a date range batch there are few credit transactions, therefore, I chose to add a row in the credit array wi...

<t>I have been searching the Internet and other resources for a practical example of how to solve a problem with two dimensional arrays. More particularly, assume MyArray() is to have two columns but the number of rows of data are yet unknown. The essence of the coding situation is:Option Base 1Dim ...