Populate Dynamic Array from Cell Values and write to Dynamic Range

Hi all...again,

Please see the attached workbook. I have a form in which the user will populate various cells with Chemical Application information. I need to get this data and populate a table to provide a running record of all chemicals applied, where, when and other data points. The approach I am trying now is a dynamic vba array whose elements are defined as:

Rows = # of Chemicals Applied
Columns = 29

I have included the expected result of the Macro in the Chemical Application Records tab of the attached workbook. The Chemical data is highlighted in green and the rest of the data points are highlighted in red.

I am using the following code:

Please Login or Register  to view this content.

When I run the macro, I get a 1 dimensional array of 28 columns when I should have a two dimensional array of 4 rows x 29 columns.

Thank you all.

TF

I've modified my code and solved one problem. I eliminated the internal i = 0 to i = 8 loop. The first row of the array is now returning the correct data, but it is still only producing an array of 1 row high by 29 columns wide. It should be 4 rows high by 29 columns wide. Any help is appreciated. My code and an updated workbook are attached.

Please Login or Register  to view this content.

...thanks. rookie mistake.