mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
Okay, I'm running a macro and part of the macro says this:
tCell = Now
tCell.NumberFormat = "mmm d, yyyy hh:mm"
I like this because of the date and time stamp. Now that I've entered this macro, it has messed up my conditional format which colored the row if the cell matched today's date. Now, that the time stamp was introduced, how can I get this accomplished based on today's date?
tCell = Now
tCell.NumberFormat = "mmm d, yyyy hh:mm"
I like this because of the date and time stamp. Now that I've entered this macro, it has messed up my conditional format which colored the row if the cell matched today's date. Now, that the time stamp was introduced, how can I get this accomplished based on today's date?