Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone please change this code to update the 24th of
each instead of thend? Thanks!!! Sub RefreshMeters() If Date = DateSerial(Year(Date), Month(Date) + 1, 0) Then MsgBox "This is the last day of the Month. Your data will be updated." ' RefreshMeters Macro ' Macro recorded 30/09/2003 by rhocarit ' ' Keyboard Shortcut: Ctrl+a ' ActiveWorkbook.RefreshAll Else MsgBox "This is NOT the last day of the Month. Your data has NOT been updated." End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
from end of month to 24th of the month | Excel Programming | |||
Change end of month to 24th | Excel Programming |