Macro to locate today's date from a list of dates
Use NOW in your VBA code.
"DOOGIE" wrote:
I am writing a macro to copy data that is recorded on a spreadsheet by the
date that the data was recorded. I want to write a macro that would either
select the current date from the list of recorded dates, or select a specific
date. I cannot seem to use the NOW() function to do this. Can anyone offer
any help? Thanks!
|