Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Languages | Excel Discussion (Misc queries) | |||
different languages | Excel Discussion (Misc queries) | |||
Bug in .FormatConditions.Add Type:=xlExpression, Formula1:=cfExpression | Excel Worksheet Functions | |||
Languages getting muddled | Excel Discussion (Misc queries) | |||
font size on formatconditions | Excel Programming |