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


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=267551

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