Do you mean a range that ignores rows that have no value? I thought you were
just referring to the last row, where A & B were null, C had a formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Richard" wrote in message
...
Thanks Bob

I have tried to insert the offset onto the range i defined as
"draughtsmenproject", so it would go two across from there. The problem is
that the null values in the cells that contained the formulas are being
taken
across to the other sheet. i was hoping to be able to use the offset
function
for the column C values only when there was a value in column A and column
B.