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