| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if is last day of month then, else
Nope. Just fixing the last one <vbg.
Ron Coderre wrote: Awww....Now you're just showing off! <g Best Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Dave Peterson" wrote in message ... Maybe even if day(date+1) = 1 then Ron Coderre wrote: Nice and concise, Dave....I like that approach. Best Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Dave Peterson" wrote in message ... Another one... if month(date) = month(date+1) then 'not the last day of the month else 'is the last day of the month end if pswanie wrote: i got a macro to copy and special paste data in order to get a accumalative sales data. i want to add to it so that it check if today is the last day of the month. something like if now() = lastday of month then run macro else range a1.value = "" end if thanx Phillip -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| 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 | |||
| Check Input for Valid Month | Excel Programming | |||
| check for last day of month | Excel Programming | |||
| Last Saturday of each month(check on Monday) | Excel Programming | |||
| Check month | Excel Programming | |||
Hybrid Mode
