Character code for upward & downward arrows

[Pasty]

Would anyone know what these are?

As I have ChrW(2191) and ChrW(2193) but it just gives me this symbol - ࢐

Regards,

Matt

 

[Andrew Poulsom]

In the Windings font they are 225 and 226, 233 and 234, 241 and 242. To use them in Excel hold down Alt and type zero then the number on the numeric keypad, eg Alt+0241.

 

[Pasty]

Hi,

I'm actually using them in my code and the font is Arial - would you know how to do this?

 

[Andrew Poulsom]

Those are hexadecimal values. Try:

Sub Test()
    Range("A1").Value = ChrW(8593)
    Range("A2").Value = ChrW(8595)
End Sub

 

[Pasty]

That worked great - thankyou.