ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Processing arrays with the for each-next construct (https://www.excelbanter.com/excel-programming/407938-processing-arrays-each-next-construct.html)

lee

Processing arrays with the for each-next construct
 
I have one array with unit numbers (1-650) in A, size codes (a-i) in B, and
third col. for search result of size code.

Second array receives unit numbers of vacant units in A.

I have programming experience but limited excel . I think The subject
construct will do what I need. It will step thru the second array getting
the unit numbers and search the first array to find the unit and put the
resulting size code in the third col.

I then want to count the results to put totals of the various size codes in
respective cells.

The subjects example says For Each element In group. I assume element is
the col. name or letter and the group is the limits of the array. Is this
right?

Secondly, how do I start the VBA function?

Sorry to be so elementary but I haven't been able to find the answers.
--
Thanks for your help.

Lee


All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com