You're either using wrong font or wrong character codes. Usual fonts, like Arial, don't have such characters.
>I know how to Insert things like PAGE NUMBER programatically through automation. This time I wanted my header to contain characters such as ♣ which is contained in Chr(5) or ► contained in Chr(16) along with other Variable/Property information of my Form. Whan I do it directly in Excel, they appear well but programatically they appear as Question marks (?).
--sb--