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