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