Macro to search through dates not working :/

[Alan668]

Hi,

I have a file that is generated everyday and I want my macro to open the file and check through all the dates in column D that are not yesterdays date. However, date is in format yyyymmdd, therefore was going to do text to columns macro to change this then run my IF statement but I am missing something as it is not working any help?

Also, I know I need to make the sheet active, however the sheet name changes daily?

Thanks
A

Please Login or Register  to view this content.

[AB33]

I suspect the date format should be

Please Login or Register  to view this content.

[Alan668]

Shall give it a bash although I think it is something more! Thanks for your reply