Hi,

Yes I knew that, but most people put titles on row 1.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Harlan Grove" wrote:

Shane Devenshire wrote...
One way to handle this is to replace the reference A1:A1000 with
INDIRECT("A1:A1000")

Works buu is volatile.

or
OFFSET(A1,0,0,1000)
....

Delete row 1 and see what you get.