Help to finish macro. It has to work in sheet "INFO".
russA1=""
dlina = Len( A1 )
'Сначала обрабатываем самые "длинные" буквы:
i = 1
do while i<= dlina
r = ""
s = lcase$(Mid$( A1, i, 2 ))
Select case True
case s = "ch": r = "ч"
case s = "sh": r = "ш"
case s = "zg": r = "ж"
' и так далее
End Select
'Проверю, малоли буква большая была:
s = Mid$( A1, i, 2 )
if ucase$(left$(s,1))=left$(s,1) then r=ucase$(r)
russA1 = russA1 + r
i=i+1
loop
i = 1
do while i<= dlina
r = ""
s = lcase$(Mid$( A1, i, 1 ))
Select case True
case s = "a": r = "а"
case s = "b": r = "б"
case s = "c": r = "ц"
case s = "d": r = "д"
' и так далее
End Select
'Проверю, малоли буква большая была:
s = Mid$( A1, i, 1 )
if ucase$(left$(s,1))=left$(s,1) then r=ucase$(r)
russA1 = russA1 + r
i=i+1
loop
thanks in advance
Bookmarks