Can you send me an example of a part number from your workbook? Also,
what column are the part numbers in and how many rows are you dealing
with (approx.)? Where are you putting this macro? Under a command
button in the "macro" section of the workbook?


--
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