The reason you get the #REF error is that the reference you used to
have (i.e. to row 4) has been deleted! The way round this is to use the
OFFSET( ) function (details in Excel Help) or to stop people deleting
rows.

Hope this helps.

Pete