I have a spreadsheet that runs throughout the day. There is a time function
built in using =now() and Text(A1,"H:MM"). Is there a way to use the time to
run a macro? I want the macro to run everyday at 16:00.

Thanks.