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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with English formula in Swedish installation
It worked fine for me. If the sheet name had a space in it, the name was
created but didn't work. If column I has no data, the name is created, but isn't a valid range if you try to use it in code. Assumes you have a sheet with a codename of xlsheet. xl2003, US English -- Regards, Tom Ogilvy "akullen" wrote: Hello, I cannot get this VBA line to work on my Swedish installation of excel 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 I 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 could do it I would appreciate it. Thank you in advance Anders -- akullen ------------------------------------------------------------------------ akullen's Profile: http://www.excelforum.com/member.php...o&userid=32513 View this thread: http://www.excelforum.com/showthread...hreadid=523521 |
Reply |
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 |