Have a small quirk. Some of the P/N's do not have letters in them, just numbers: (such as 1047663). I should have included those in my example.
Excel is generating this error:
I've tried to change the date type to something else, but the error persists. Any thoughts?
EDITED NOTE: (I can place a TEXT qualifier in front of the P/N column in my table, copy, paste back as values, replace the original column and it works, but maybe there's a data type thingey that would do the trick in the code.)
Many thanks if you could take another look.