I have a spreadsheet that performs statistics calculations on sheet 2 and is
protected, the operator enters data on sheet 1. The formulaes fail to work
(result is #REF!) on sheet 2 because the operator has a habit of deleting
rows on sheet 1 that upsets the named ranges. The problem persists even if
I use ISERROR in my functions. I cannot protect sheet 1 because the
operator needs to use the sort drop down menu. I need some VBA I think, but
I don't know enough to do it quickly. Can anyone tell me how I can stop the
operator deleting rows or is there a workaround here?

many thanks

Charlie Brown