In VBA, use the Asc function.

Debug.Print Asc("A"), Hex(Asc("A"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)



"SupperDuck" wrote in message
...
Hi,

I use =code function in excel to see the ascii code for a character. But
when i try to use the "code" function, it crashes.

Could you please advise the code to see the ascii code?

Thanks and regards,