FormatConditions (fails in different Languages)
 

We are using VBA to define an Excel FormatCondition using the cod
extract shown below:

With Range("Tit_Email").Offset(Particip
0).FormatConditions
.Delete
.Add _
Type:=xlExpression, _

Formula1:="=OR(AND(ISERROR(FIND(""@"";R[0]C[0];1));len(R[0]C[0])0);RIGHT(R[0]C[0];1)=""."";RIGHT(R[0]C[0];1)="","")"
End With

This code works fine for some Regional Settings on the computer runnin
the VBA code. (E.g. "English (United States)", "English (Unite
Kingdom)", "Japanese".) But when the Regional settings are eithe
"Portuguese (Brasil)" the Add method fails. The Formula1 are no
updated to:

(L[0]C[0])0);direita(L[0]C[0];1)=""."";direita(L[0]C[0];1)="","";direita(L[0]C[0];1)=""@"")"
in Portuguese for example.

If anyone has seen this or similar problems before I would greatl
appreciate any suggestions for a solution or workaround to thi
problem. For reference, this problem was observed on systems runnin
Excel 2000 (9.0.2720) on Windows XP.

This error is similar than this another i
http://www.experts-exchange.com/Appl..._20879800.html
:( :confused

--
Message posted from http://www.ExcelForum.com