Problem with English formula in Swedish installation

[akullen]

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

 

[Tom Ogilvy]

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