If it's easier, you don't have to rewrite all my code... a layman's explanation of arrays specific to my purpose would be worlds of help. Again in a nutshell:
I want to copy data to an array, out of a oddly formatted web query.
I can get to continuous ranges with a loop, those are the data I wish to copy.
The data ranges vary in length but are all 7 columns wide.
After loading a range to an array, I want to continue the loop that looks for the next "block" of continuous data, coping/appending this to the same array.
Thanks again...
It is certainly not the most garbled mess by a long shot, and the comments are helpful. Please be patient, as sinuses/head about to bust.
If you're still online, a couple of questions/comments to help get it thru my thick head...
I believe I understand that you want to load an array 7 cols by unk rows... and that there are discontiguous ranges of these "tables" - so you want to be able to find the next range and loop it into the array.
*
Now to "draw the blonde guy a picture", please correct any of the above I have incorrect, and tell me if there's things we can count on or not. For example:
Lets say there's five ranges. Lets say the first one starts at A1 and ends at G122 (I realize the row may be 132, 147, or whatever, the next day).
Now, when we look for the next range, where are we looking? For instance, will it always be farther down (higher row numbers), or might there be a range that starts in L22 or some other place off to the side so-to-speak.
What is between the ranges? Can we count on truly empty cells (no weird unprintable characters)?
And I think yo already stated this, but to make sure - once we run into a blank cell (row) in one range, we can look for "company" to be in the upper/left cell of the next range, right?
Thank you, and sorry its taking me a bit to "see" your sheet.
Mark
*- ACK! I forgot. After making one big array, we're planting it some place on the other sheet...