Sub HAZARDSNONEANDNA()
Range("D34:D36").Value = "♂"
the code didn't work, when I paste the symbol into the code it turn into "?"

Is it macro doesn't allow specific text such ♂ ?

Help me to solve this.. Thanks