Unable to Transfer Array Contents to Worksheet Range

Hello,

the error occurs 'cause the variable g is empty ! Easy to check … So you must revise the logic used …

Originally Posted by Marc L

Hello,

the error occurs 'cause the variable g is empty ! Easy to check … So you must revise the logic used …

Thank you, Marc. I have sourced the problem in the logic and made the correction to solve the error. However, the objective of the code is to transfer the rows of data captured in the array (g) to the target range (GroupListImportRange) on the worksheet. However, only 1 row from the array is being transferred to the target range. There should be two rows transferred in the sample file. I do not know what changes I need to make to capture and transfer the complete set of data rows, rather than just one. Thanks for any assistance you can provide. I have included an updated file with the correction.

g never gets populated, I stepped through your code

If there is only record row to copy when the error occurs, why is your array g filled with 2 records?? Check in immediate screen when code stops

Originally Posted by nigelog

If there is only record row to copy when the error occurs, why is your array g filled with 2 records?? Check in immediate screen when code stops

Array g works fine and is filled correctly with two records; those two records make up the Group record being processed from array b, and there will always be at least two records in g (it takes two to create a group).

Array b (as reflected in the code above) is the one that may only contain one record (there may only be one Group), or it may need to contain multiple Groups. The code works fine when array b contains more than one record, but fails when there is only one record.

The result of the failure is evidenced during transfer of the record from array b to the target range ("GroupImportRange")(it puts only the item from the first column of array b into all the worksheet columns in the target range).

Hope this helps clarify.

Second element of the array "b" is a "Null" value, is that the cause??

Good question. But no, null values in array b are text strings inserted into unused fields for a Group record. You will see them in the source table. Again, everything processes as intended when there are multiple records in array b to loop through. I think it has to do with how to populate an array when there is only one item vs multiple items; and how transfer the record(s) out of the array when there is only one item vs. multiple items. Somehow I need to accommodate both, but so far have failed. I thought the below would solve for this, but it doesn't work either.

Please Login or Register  to view this content.

Still needing some serious assistance here. Have tried the changes in red below. The code will process without error, but does not function properly. When array b contains only one one row, the transfer of that row of 29 columns to the target range results in the data element of the first column in the array being transferred to ALL the columns of the target range. This does not happen when array b contains more than one row to loop through. Any help is much appreciated.

Please Login or Register  to view this content.

Still in need of help on this. Can anyone assist?