VBA - write "=>" as string in a cell

Question

I'm trying to write in a cell this string "=>". Macro gives "error 1004".

Macro works correctly if I write "=>x" where x stands for another character.

What am I doing wrong?

Thanks

Answer 1

You can format it as text before entering the value:

With ActiveSheet.Range("A1")
    .NumberFormat = "@"
    .Value = "=>"
End With