The cell contains the CONCATENATED result of 2 adjacent cells
1. Height represented as number i.e. 55
2. Date value i.e. 12/12/2004
3. cell result = "55 12/12/2004"

When using insert name define from the commandbar the resulting tex
is converted to
_55_12_12_2004

The code "ThisWorkbook.Names.Add Name:=s, RefersTo:=r"
on this particular cell returns
run-time error 1004
That name is not valid

If there anyway to overcome this problem

--
Message posted from http://www.ExcelForum.com