Monthend = Application.Run("ATPVBAEN.XLA!EOMONTH", Range("daterange").Value,
1)

"Pete" wrote:

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