Good morning Alan,
I don't know what is wrong but still it's giving error 'function or variable required".
Please change the required change in my file and send it to me. What do you mean earliest time '07:55:00'
I want the macro to be run once daily at a given time.
First sort and then anniversary.
I don't want to be run it after that in a daytill next day at given time.
These are the only requirements of my program.

Please check the file and sort out the problem.

Thanking you in anticipation.

Mukesh