I often use the Names Collection to dynamically store constants.
I need to add a numeric text string to the Names Collection, but when I do, Excel converts the string to a numeric value.
For example, this code snippet
thisID = "0011223"
ThisWorkbook.Names.Add Name:="myID", Refersto:=thisID
stores 11223 as the value for "myID" in Names, not "0011223"
I'd like to retain the string represtation for this number.
I've tried using Refersto:=CStr(thisID), but that does not help.
Any suggestions would be appreciated!
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?