Thanks Otto, but the end of the document as perceived by Excel is only
a few lines below the text. I think the problem more relates to the
fact that because the formula for each line is dependant on the line
above it, if you change a line all calculations in the lines below are
recalculated. I was hoping that someone has done something similar or
a formula guru could have a look at my logic.

Regards,

Geoff.