That did the trick. Thanks!
Forgive me for imposing on you one more time, but if column "H" contains
"current" part numbers, and column "I" contains "previous" part numbers, can
you tell me how to modify your code so that it will search both columns per
sheet?
Thanks again.
Bob


"kev_06" wrote:


Just add:

SearchPartNum = UCase(SearchPartNum)

below the line:

Loop Until Not SearchPartNum = ""


This will convert all text inputted through the inputbox to capital
letters.

If you need anything else, write back.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=570599