Date Logic Locking up and not calculating

[ExcelMonkey]

I have some EOMONTH() funcitons that I am using in an Excel Macro with a
lot of macros. It periodically fails to update. If I go into the
formula and hit enter, the function updates properly. Otherwise, it
stays constant across a range which should be icremententing by month
(i.e. EOMONTH(A2,1).

I should have:

AprilX30 MAyX30 June31X etc

Instead I get

AprilX30 AprilX30 AprilX30 etc

F9 does not help and my addin is selected.

Can anyone tell me why this is? Is this related to macros?

RK

 

[Jan Karel Pieterse]

Hi ExcelMonkey,

I have some EOMONTH() funcitons that I am using in an Excel Macro with a
lot of macros. It periodically fails to update. If I go into the
formula and hit enter, the function updates properly. Otherwise, it
stays constant across a range which should be icremententing by month
(i.e. EOMONTH(A2,1).

Why use a user defined function for this?

=DATE(2004,10,0) gives the date of the last day of september (yes,
september, NOT october!).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com