Mar 15 2022 06:31 AM - edited Mar 15 2022 06:41 AM
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:
Mar 15 2022 07:15 AM
Solution
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 "?".
Mar 15 2022 05:15 PM
Mar 15 2022 07:15 AM
Solution
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 "?".