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