VBA code to highlight and select a particular pattern

Can anyone help me to develop a vba code that can highlight and select a pattern in a dataset

E.g

No. W1 W2 W3 W4 W5
1 3 5 20 12 43
2 13 67 18 55 4
3 90 78 5 1 66
4 55 20 15 12 9
5 1 32 67 8 29
6 23 4 5 23 12
7 45 34 65 12 43
8 32 59 21 43 19
9 67 13 73 29 15
10 4 84 73 37 8

With the data from cells range A2:E5000, i would like to get all the pattern I specify highlighted and selected to another workbook.

w1 w2 w3 w4 w5
Select Pattern: [3] [22] [13] [34] [12]
[73] [15] [56] [49] [55]

In this case 12 & 55 (lapping) will be highlighted from No. 1&2 in W4. Any vertical lapping in the pattern will be highlighted and selected to a workbook.


I hope I have explained my challenge clearly.

Originally Posted by Leith Ross

Hello ubatu05,

Are you doing horizontal matches also?

Will the pattern always be 2 rows of 5 numbers?

Yes please, two or sometimes three rows of 10 numbers maximum.