Dear frineds,

I have an Excel table like below,


A B C
1 Box Number Seal num. from Seal num. to

2 BOX 1 004569 004600

3 BOX2 020034 020106

4 BOX3 000237 000320

5 BOX4 001003 001130



I want to write a macro to search a Seal Number with in the series. For example,
When I input 020100, it should highlight the row 3. as well when I input 000300
It should highlight row 4.

Could anyone give me a bright idea as how to do this?
Thank you in advance.