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

Probably the E5 cell is #NAME as well. If so, try and solve that one first.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CarolineHedges" <CarolineHedges.2cj1eq_1155553805.6532@excelforu m-nospam.com wrote in message
news:CarolineHedges.2cj1eq_1155553805.6532@excelfo rum-nospam.com...
|
| 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
|