i am going to have 3 columns in a row, that stay the same
and then after that i could have 1 to 12 more columns of data.
PartNumber
Description and
Asy will all ways be present
The 1st row will look like this, which is basically a header except for the Qty's, these are read in from a database and could be just 100, or all 7 values like below, this will be dynamic.
Part Number  |  Description  | Asy |  100  |  200  | 300  | 400  |  500  |  600  | 700
The same is true with the rows, there may be 1 row or there may be 10 rows.

When this is all said and done it might look like this
Part Number  |  Description  | Asy |  100  |  200  | 300  | 400  |  500  |  600  | 700
32302-06232 | MY TEST _1  |   1   |  .023 | .232  | .45   | .121 | .046  |  .45   |  .45
10255-06232 | MY TEST _2  |   1   |  .023 | .232  | .45   | .121 | .046  |  .45   |  .45
22222-00000 | MY TEST _3  |   1   |  .023 | .232  | .45   | .121 | .046  |  .45   |  .45
I need to know if there is a way to determine how many rows and columns i am going to have to fetch, so i can create a loop and write all this data back to the database. For the example above i know (From looking at it) that i will have 3 rows of data that i need to updata and that i need to go out 7 columns past the static data to get all the Qty's. I know this because i am looking at it, but i need to be able to know, when i click to button to update the Database, how many columns and rows i need to get.
I just dont know how to account for the dynamic data that will build the sheet.

If this was all static and it was always going to be 6 columns and 4 rows, then this would be easy (for me at least) but i have not done alot with Excel and VBA to know what i need to do.

So with that, i ask you guys for help.

Thanks.