Macro for Marking/finding out the cells which are having other than English alpha or numerics

[anchuri_chaitanya]

Hi All,

Need assistance and/or help from the team on one of my work.
In a workbook dealing with huge data every day. In one of the columns lets say column K, cells containing data other than English Language (A-Z, a-Z, 0-9, / , . ! # % $ ^ & * ( ) _ + = ~ `| \ } { [ } / ? . > < also space), like mainly urdu letters or foreign language alphabets.

Here I want those cells to be marked/colored automatically if I click on a button placed in the work sheet. Is there any possible help I may get.

Please help me on this.

thanks & regards
Chaitanya

 

[Mahesh_P]

Hi

it would be great if you could post screenshot of worksheets column K.you can use vbhtml maker www.mrexcel.com/vbaddin.shtml

As per my knowledge there is not any function which will return LCID code or HexLCID Dec
for a particular cell. http://msdn.microsoft.com/en-us/goglobal/bb964664

however i have found a code on below link which return the default language set for excel.
http://stackoverflow.com/questions/8588728/excel-2010-vba-find-the-current-user-language