Skip to content

Instantly share code, notes, and snippets.

View jenikm's full-sized avatar

Eugene Magdel jenikm

View GitHub Profile
@jenikm
jenikm / vba_russian_transliterate.vb
Created June 29, 2012 19:44
VBA Russian transliterate function
'http://www.utf8-chartable.de/unicode-utf8-table.pl?start=1024&utf8=-&unicodeinhtml=dec
'use numerical HTML column
Function Transliterate(Russian As String)
letters = Array("A", "B", "V", "G", "D", "E", "YO", "ZH", "Z", "I", "Y", "K", "L", "M", "N", "O", "P", "R", "S", "T", "U", "F", "H", "TZ", "CH", "SH", "SCH", "", "Y", "", "E", "YU", "YA", "a", "b", "v", "g", "d", "e", "yo", "zh", "z", "i", "y", "k", "l", "m", "n", "o", "p", "r", "s", "t", "u", "f", "h", "tz", "ch", "sh", "sch", "", "y", "", "e", "yu", "ya", "#")
i = 1040
For Each letter In letters
Dim val As String
Select Case letter
Case "YO"
val = ChrW(1025)