Remove Second Language From my Document
 

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


--
laheq
------------------------------------------------------------------------
laheq's Profile: http://www.excelforum.com/member.php...o&userid=25285
View this thread: http://www.excelforum.com/showthread...hreadid=387736

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.

Thank you for your reply. I will try that.


--
laheq
------------------------------------------------------------------------
laheq's Profile: http://www.excelforum.com/member.php...o&userid=25285
View this thread: http://www.excelforum.com/showthread...hreadid=387736

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