If it is always one extra row just subtract 1

=offset(cell,0,0,counta(range)-1,5)


Regards,

Peo Sjoblom

" wrote:

Hi ALL:
I created a dynamic range name Production that refers to the following
formula = offset('daily production output'!$a$1,0,0,counta('daily
production output'!$a$a),5)which is is to be used in a pivot table.
However when I enter data in the range, one row of blanks is always
selected along with row of data. Labels are in a1,b1 etc.
Any help will be appreciatedto solve this problem