If Day(Date) = 1 Then
Call myMacro
End If

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Lonpuz" wrote in message
...
At the beginning of each month, I need to copy/paste value over a number
of
formulas so the results become fixed. I know how to automate the process
using the recorder, but want it to do it automtically when the 1st of the
month comes. I'm sure I can do that by making reference to a today()
formula, but don't know how to write the code. My apoligies if this was
already posted somewhere, as I couldn't find the exact info I was looking
for.

Regards,

Lonpuz