Thanks Guys - much appreciated.

"Duke Carey" wrote in message
...
Press the F5 key, type in your dynamic range name, click on OK, and Excel
will select the range.

In your case, your defined range will NOT INCLUDE the last number in the
list. Either change the offset to reference cell A2, or add 1 to the
COUNT(A:A)


"Andibevan" wrote:

Hi All,

I am having problems with dynamic named ranges.

On my table I have defect ID's (numerical) running from a2:a200 and the
title"Defect ID" in cell A1

I am using the following formula to dynamically name a range:-

=OFFSET($A$1,0,0,COUNT($A:$A),1)

Will this format of offset select A1:A200 as the named range or A2:200?

From my understanding you can't physically select a dynamically named
range
so it is hard to tell what it is selecting

Thanks

Andi