That worked fine, though object to 22 series in a chart
22 pairs of error message later.

It was a defined name, I deliberately used a name for the area I was  
refereing to so that when I copied the sheet to a different workset I  
could ensure the code, worked by setting/checking the defined name.

What caught me, and I didn't know until I deleted the names, was that each  
name was defined twice, the first linking to the dead file invisible until  
I deleted the 2nd name which of course was working fine

I cheked the names, thinking that might be an area of concern, but of  
course couldn't see the 1st defined names

Bit naff, but thanks to your link - fixed

Steve