Remove Second Language From my Document

L

laheq

I have a huge document that has many sheets and in every sheet there
some fields are in English and some in Russian. I want to Remove All
the russian text from my document.

If you have any Idea, please help.
Thank you
 
D

Dave O

Is the Russian text formatted for Cyrillic font, or do those cells have
a unique property not shared by the English text? If yes, you could
write a quick bit of code to look in each cell for that particular
property, and if the property exists for a cell, delete its contents.
 
D

Dave O

Didn't mean to be vague about the code: here's an example of code to
look in each cell, and un-shade a cell that is currently yellow:

Sub Find_Yellow()
Dim rCell As Range
For Each rCell In ActiveSheet.UsedRange
If rCell.Interior.ColorIndex = 6 Then rCell.Interior.ColorIndex = 0
Next rCell
End Sub
 
Top