Remove Second Language From my Document

[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

 

[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.

 

[laheq]

Thank you for your reply. I will try that.

 

[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