cannot display the sterling symbol "£" in vba?

[yellowpower]

Hi guys,
I need to input the sterling symbol in my vba code, but seems like it will become "?" every time I insert the £ symbol. Any idea how I could solve this problem?
Many thanks

Allen

[solnajeff]

Hi

You could try using Chr(163) instead as that should work correctly when output to a sheet.

Regards

Jeff

[Marcol]

Try on these lines

Please Login or Register  to view this content.

Adjust the range to suit your situation.