I am reading imported data that occasionally separates a conformation number into its own cell. Thus when I read it I get the dreaded, "Run-time error '6'".
If I know it is a number and the previous cell ends with, "Confirmation #:" or, "confirmation number is" then I can handle it. But I...