Modify VBA to also write matching matrix pattern as cell reference name

Excel 2010 - Modify VBA to also write matching matrix pattern as cell reference name in column EE

Can someone lend me a hand with this please?

Everything works, there is not a single problem. I simply need to add a new output in column EE using the existing VBA macro (add one more thing to do to the existing macro).

I have a sequence of numbers which are checked against a matrix full of numbers, and if it is a match (per row), then how many of those matrices are matched is recorded in column EA and also which Matrix assigned number was found to match in column EC.

If you open the attached file, simply click the RED button labeled "AUTO FIND MATCH" and once it is done, scroll to the right all the way to column "EA" and you will see how it records how many grids (there are a total of nine) the sequence of numbers (starting in row/cell C1) did match and in column "EC" it will record the grid assigned number that matched (the grid numbering starts on "BB58").

Once again, everything works flawlessly, there are no errors.

What I need now, is that the VBA macro (found in MODULE 1, called "Sub Python3AutoFindPatterns()") that it is being used with the RED button ALSO OUTPUTS per row in column EE which cells (cell reference names) were used to find a match for each row using the grid that start in "BF12" which is labeled "Matrix 2" (Matrix 1 could also be used).

This Excel file also has code in place to do it manually one by one, one row at a time. So, to illustrate better what I need, using the manual mode, simply click on cell "S1" and it will be marked with a red X (just by simply clicking on cell S1). You will now see numbers inside Matrix 1, and X inside Matrix 2, and they correspond to each other. Scroll down the sheet and you will also see that on cells BU59, BZ59, and CO59 it is displayed "FOUND" and the cells are GREEN. This indicates that three grids (numbers 5, 6, and 9) match with the same number sequence listed in cell C1, D1, and E1.

What I need is that on cell EE1 (corresponding to the first sequence that starts on C1) the VBA macro outputs the cell names that were used for this matching sequence based on using Matrix 2.

Of course that if nothing matches (if the outcome is zero) then column EE should have nothing accordingly. It will be blank.

Here is an example of the outcome I need (doing it manually):
-Click once on cell S1 and the grid called Matrix 1 shows numbers, and Matrix 2 show X.
-Since this sequence is found to match (see range BA59:CO59), then using Matrix 2, the output in column EE1 should be: BH14, BF15, BI15 (indicating that those cells were the ones with the X in Matrix 2, for row one).
-The same should be for row C2. Cell EE2 should list (separated by commas) the cell names used if the grid does match, etc.

Doing it manually will not record the needed output in column EE. Only by using the RED button the VBA macro should output the desired cell reference in column EE. I need this new output only when using the RED button, not when doing it manually.

I thought of adding an IF-THEN-ELSE to the macro but I have not been able to make it work (for example using Matrix 2:

Please Login or Register  to view this content.

but I have not been able to correctly concatenate the IF for all 28 cells of the grid and to list the output separated by commas in column EE (BH14, BF15, BI15).

When using the red "AUTO FIND MATCH" button (linked to the macro in Module 1 called "Sub Python3AutoFindPatterns()"), the desired output in column EE should be:

In cell EA1: 3
In cell EC1: 5, 6, 9,
In cell EE1: BH14, BF15, BI15

In cell EA2: 3
In cell EC2: 5, 6, 9,
In cell EE2: BF13, BI13, BH14

In cell EA3: 3
In cell EC3: 5, 6, 9,
In cell EE3: BG12, BH12, BH14

etc...

In cell EA17: 3
In cell EC17: 5, 6, 9,
In cell EE17: BH12, GB16

In cell EA18: 2
In cell EC18: 2, 5,
In cell EE18: BF13, BG15

etc.


Here is the macro I need to modify:

Please Login or Register  to view this content.

I hope I make sense. If not, I apologize.

In advanced, a billion thanks for any help given.