sory little error on previous post


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
range a1.value =""
else
run mymacro
end if


thanx
Phillip