View Single Post
  #3   Report Post  
doco
 
Posts: n/a
Default

Quote:
Anyone familiar with all of this?
Yes.

Beyond that I am not sure what your question is...


"Pat" wrote in message
...
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