Thanks so much for the help.

I am getting a Run-time error '1004' Method 'Range' of object'_Global' failed

at

For Each rngPartnumber In Range ("partnumbers")

any thoughts?