I have this formula in excel:
="Nav as at "&TEXT(EOMONTH(Menu!E5;0);"dd mmmm yyyy")
It works perfectly, until I delete a line in the workbook, for no
apparent reason at all.
(The date the formula works on is in a different worksheet cell E5.)
Does anyone know why this happens?
The cell the formula is in is B5. Whenever I delete Row 14, the formula
returns value #NAME?
Please help me with this one
Thanks
--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
View this thread:
http://www.excelforum.com/showthread...hreadid=571324