jagged arrays

I've got a VBA UDF which extracts (multiple) numbers from a string, cell, range, or array. It's used in a variety of scenarios so it needs that flexibility, and generally worked EXCEPT...when the range has different result sizes in different cells The function returns a single number, array of...

I know I can quickly fill a worksheet with an array referencing a value using something like this: Dim thisArray(6 To 139, 6 To 40) As Variant Dim x As String dim row, col As Integer for row from 6 to 139 step 1 for col from 6 to 40 step 1 thisArray(row, col) = row * col next col next row x =...

I have populated a variant that is initially 1D from a worksheet using the Range.Value function. By the Split function this array then become a jagged array leaving me with an array like: <table border="0" cellpadding="0" cellspacing="0" width="107"><tbody><tr style="height:15.0pt"...