Forum Discussion
Solved
Mystery Character
Can anyone explain why running the following code
Msgbox Sheets(1).Range("A1").Offset(1,0)
on the attached workbook returns a ? before the C:\
Looking at the xml code does not reveal anything before the c:
MsgBox Hex(AscW(Sheets(1).Range("A1").Offset(1,0)))
displays 202A. Unicode character 202A is Left-to-Right Embedding
This is an invisible character, but VBA displays most Unicode characters as "?".
2 Replies
MsgBox Hex(AscW(Sheets(1).Range("A1").Offset(1,0)))
displays 202A. Unicode character 202A is Left-to-Right Embedding
This is an invisible character, but VBA displays most Unicode characters as "?".
- Thanks, Hans.
I am surprised that nothing appeared in the xml code, or was I looking in the wrong place
