Mystery Character

[Doug_Robbins_Word_MVP]

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:

[#2 · Accepted solution]

@Doug_Robbins_Word_MVP 

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 "?".

[#3]

Thanks, Hans.

I am surprised that nothing appeared in the xml code, or was I looking in the wrong place