I'm sorry to interrupt, but I cannot start a new thread. Do I need to change
security settings or something? Thanks, Bob

"JMay" wrote:

Is 6Fields.xls a separate workbook? Looks like it is.. If so Open it
along with your active Rangenamed book and re-examine the Name Refers to
box; even altering it to suit. Save your file.

"Graham Haughs" wrote in message
:

I have a program which has a named range as shown below, which is one of
many named ranges.

=OFFSET(Fields!$A$5,0,0,COUNTA(Fields!$A:$A)-5,6)

Now someone has tried to copy the program and in doing so has
transformed this particular named range to the convoluted mix shown below.

=OFFSET('C:\Dev\projects\central
fabrication\[6Fields.xls]Fields'!$A$5,0,0,COUNTA('C:\Dev\projects\central
fabrication\[6Fields.xls]Fields'!$A:$A)-5,6)

What I would be most grateful for is for someone to tell me, step by
step if possible, exactly what they think would have been done with the
original program or named range to arrive at this situation. I cannot
see how copying the program itself to the directories in the C drive
detailed would do this, I can only think there has been some copying
and pasting to a clean sheet but I just cannot work out how or what. I
would value any guidance at all on the mechanisms that were involved in
this conversion.

Kind Regards
Graham Haughs
Turriff
Scotland