You obviously have data in C1:C77 thus it will be counted, you can use
=OFFSET(Centre!C$77,0,0,COUNTA(Centre!$C77:$C65536 ),1))
Regards
Peo Sjoblom
"Pat" wrote:
The defined range below extends the range beyond the cells where the data
ends.
The start of the range is Centre!$C$77 the end of the range is C1054. The
last cell containing data is C807. The data in C is the result of a formula
and is in the range C77:C1000
=OFFSET(Centre!$C$77,0,0,COUNTA(Centre!$C:$C),1)
Anyone familiar with all of this?
Thanks if you can help.
Pat
|