"Gary''s Student" wrote:

Sub apostest()
MsgBox (Range("A1").PrefixCharacter)
End Sub

Exactly what I needed, Gary would be proud.

Well, Gary might be proud except, perhaps, for those extraneous parentheses
around the MsgBox argument.<g

Rick