if worksheets("Sheet1").Range("A2").Value = Date - 1 then exit sub

--
Regards,
Tom Ogilvy


"Sandy" wrote in message
...
Hello Group
What should I add to my code to prevent it from being run once a day?
Once
updated yesterdays date is in A2 of sheet1.
Thanks!