highlight consecutive series of four numbers vba
Hi,
Will any of the ranges overlap e.g. 6 (or more) consecutive numbers
123456
will any consecutive numbers wrap around 2 rows i.e. the last 2 rows on 1
line and the first 2 on the next be a consecutive series?
Mike
"smandula" wrote:
I would like to highlight all four consecutive sequential
numbers in range of C2:V25
1 2 3 4 11 23 36 42
25 26 33 34 35 36 40 45
1 2 3 4 and 33 34 35 36 will be highlighted only
any color.
With Thanks
.
|