| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with English formula in Swedish installation
Hello, I cannot get this VBA line to work on my Swedish installation of exce 2003. ActiveWorkBook.Names.Add _ Name:="Lables", _ RefersTo:="=OFFSET(INDIRECT(" & Chr(34) & xlSheet.Name & "!J2" & _ Chr(34) & "),0,0,COUNTIF(INDIRECT(" & Chr(34) & xlSheet.Name & "!I:I" _ Chr(34) & ")," & Chr(34) & "0" & Chr(34) & "),1)" If I do it with RefersToLocal and put it in Swedish it works and if then echo it, its syntax matches the one above (Except the variables)! Am I doing something wrong or might it be a bug? I do not have an English installation to try it on so if someone coul do it I would appreciate it. Thank you in advance Ander -- akulle ----------------------------------------------------------------------- akullen's Profile: http://www.excelforum.com/member.php...fo&userid=3251 View this thread: http://www.excelforum.com/showthread.php?threadid=52352 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using english and non-English Excel commands simultaneously in anon-English installation | Excel Worksheet Functions | |||
| Swedish Excel problem | Excel Discussion (Misc queries) | |||
| OR formula, translation to swedish please | Excel Discussion (Misc queries) | |||
| How do I convert my swedish version of office 2003 into an English | Excel Discussion (Misc queries) | |||
| o2ksr1a installation problem | New Users to Excel | |||
Threaded Mode
