check if is last day of month then, else
Maybe even
if day(date+1) = 1 then
I really like that one!
Rick
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
|