| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End Of Month
And if you set a reference to the ATP in the VBE (Tools/References, check
ATPVBA), you can write it as MonthEnd = EOMONTH(Range("DateRange").Value) On Fri, 25 Mar 2005 13:55:02 -0800, Stratuser wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
