Macro to find today’s date in list

This code will do what you're asking, but I have one concern with your data and that is how it's entered in each cell.

Please Login or Register  to view this content.

Hi PFDave, that worked a treat! Thanks! Sorry to be a pain but would it be possible to explain how that macro is working? Just so I can understand it for the future and if I need to adapt it I can learn for myself a bit better!

Of course I can

declare variable names and their type:

Please Login or Register  to view this content.

Set variable for ws

Please Login or Register  to view this content.

This creates the the loop which we are using For Each in a certain range. the ws.Range part is setting the range which we could do prior by declaring and setting another variable. N.B - We're using UsedRange to find the last row we want to use

Please Login or Register  to view this content.

To declare and set another variable for the range we would

Please Login or Register  to view this content.

This would then change the For Loop to

Please Login or Register  to view this content.

Next we're checking if the cell (c) is = to todays date and if it is we want to select it and exit this routine because we've found what we're looking for. If it's not equal to todays date it will move onto the next cell in the range

Please Login or Register  to view this content.

Awesome thanks Dave! Will mark as solved when I’m not on my phone as I can’t seem to find the option! Really appreciate your help!

Glad it's sorted mate, any feedback greatly received