I sorta screwed up my explanation <<sorry
*REVISED*

Test refers to the range:
A5:F?C? $A$5 regardless as it is the ANCHOR Cell



"JMay" wrote in message
:

Well AT PRESENT the below formula which appears in the RefersTo:
Box of a NamedRange say Test
Test can be used to refer to the range:
A?R?:F?C?

where ?R? is determined by
The total non-blank rows in Column A minus 5 -- say equals to 50
so formula brings back 50 rows beginning at A5 down to A49

AND ?C? brings back 6 Columns (Thru Col F)

So test = A5:F49

Does that help?


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

"Graham Haughs" wrote in message
:

Thanks for quick feedback. To explain a bit more to clarify, someone has
been a bit "naughty" (my kindest language at the moment) and copied a
program and modified cosmetically. All the named ranges other than this
one relate to sheets in the workbook which still exist. The sheet
"Fields" no longer exists in the copy program which I think caused this
aberration.Yes I think the workbook has been called 6Fields.xls that it
was copied to but I am trying to understand the mechanisms of how it was
arrived at from the original, I don't need to sort it.
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