Transliteration from Latin to Cyrillic letters in Excel

[kecman]

I am trying to convert text from Serbian latin to Serbian cyrillic.
The text is in column A of a worksheet in Excel. I therefore recorded
a macro using the search and replace function. The manual search and
replace works perfectly (but is a big hassle), but the macro does not
record properly.

For example, I want the letter "d" to be replaced by "Ä". In the macro
editor, the following is recorded:

Selection.Replace What:="d", Replacement:="_", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True

The problem is that I cannot input cyrillic letters in the macro. I.e.
the problem is in:

Replacement:="_"

which should read

Replacement:="Ä"

Is there a way to work around this problem? Thanks!