SOLVED

Mystery Character

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:\

Doug_Robbins_Word_MVP_0-1647350868220.png

Looking at the xml code does not reveal anything before the c:

Doug_Robbins_Word_MVP_0-1647351647404.png

 

 

 

2 Replies
best response confirmed by Doug_Robbins_Word_MVP (MVP)
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 "?".

Thanks, Hans.

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