I have a worksheet with formulaes which reference the line above. When I insert a new blank line, the formula does not change to reference the new line. Is there a way round this please? I know I would get errors because the data in the blank line would not suit the formula, but I can work around that part.

=IF(MONTH(C163)>MONTH(C162),TEXT(C163,"MMMM"),"")