Unable to split the string using Chr(150)
Trying to spilt the string using Chr(150) which is ASCI representation of "-". But below error is displayed. Sub SplitDemo2 SplitDemo2 Dim s, ss s = "May 26 - June 25" ' Split at...
Forum Discussion
YMinaev
Staff
StaffHi,
We've found a problem in your code. The "-" symbol has the #45 code, while you're trying #150. Use Chr(45) instead of Chr(150).
We've found a problem in your code. The "-" symbol has the #45 code, while you're trying #150. Use Chr(45) instead of Chr(150).