ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date (https://www.excelbanter.com/excel-worksheet-functions/116154-date.html)

justvree

Date

I"m doing a macro that needs to search a list for today's date, and return
information based on what it finds. I've tried searching for TODAY(). I'm
going to try DATE(). What would be your suggestion?

Do until ActiveCell.Value=Date() is my thinking... can I get a concurrence?

V.

Stefi

Date

Do until ActiveCell.Value=Date
Regards,
Stefi

"justvree" wrote:

I"m doing a macro that needs to search a list for today's date, and return
information based on what it finds. I've tried searching for TODAY(). I'm
going to try DATE(). What would be your suggestion?

Do until ActiveCell.Value=Date() is my thinking... can I get a concurrence?

V.

All times are GMT +1. The time now is 07:02 PM.