According to Excel Help, the arguments of CreateNames method are optional:
yet I found that even after I specify one, in VBA, Excel STILL guesses for the text labels. This happens only when the values are texts.
So for example, I have two columns range, say "A:B". "A" contains text for the...