Try this Pete

If Month(Date) < Month(Date + 1) Then MsgBox "This is the last day"


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Pete" wrote in message ...
How can I detect if the End Of the month has been reached
from within VBA

I know you can use EOMONTH in Excel, is it available in
VBA?

Pete