Set a range of cells for searching missing combinations

[JOAO12]

Hi everybody,

The following macro searches for missing combinations. This macro will search the complete list and will return any missing combination from "1, 2, 3, 4" to "7, 8, 9, 10".

Please Login or Register  to view this content.

I need your help to make some changes in this macro, so that it will search for missing combinations only within a specified range of cells (and not the whole list). For example (see excel file attached), I would like to place a search within range("G23:J183"), from combination "1, 2, 6, 9" to combination "4, 6, 8, 10". In this case, it should return only 9 missing combinations.

Any help is welcomed. Thank you very much.

John

[sktneer]

May be you need to change the line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[JOAO12]

Hi sktneer,

Thanks for your reply. Now this macro returns all combinations BEFORE combination "1, 2, 6, 9" (that is, all combinations before range("G23")) and all combinations AFTER combination "4, 6, 8, 10" (that is, all combinations after range("J183")).

What changes should be made in order to make this macro return only the missing combinations BETWEEN "1, 2, 6, 9" and "4, 6, 8, 10" ? How could I change the values of "a", "b", "c" and "d" in order to achieve this goal? If I set the values as: "For a = 1 to 4", "For b = 2 to 6", "For c = 6 to 8", "For d = 9 to 10", then this macro makes a big mess. The main point is that this list is about a series of number combinations (numbers "1", "2", "3", "4", "5", "6", "7", "8", "9" and "10" combined 4 by 4).

Thank you very much.

John