How do I store the current date to a variable and compare it to cells that have dates?

Here is the current macro I am working with.:

Please Login or Register  to view this content.

I am trying to change an Excel file from the bottom-up until I find a date that is not today's date (where today means the day you look at the file and not the day this forum post is posted) in which case, I just want the copying process to stop but I am not able to successfully compare the dates.

The compiler says:

Run-time error '1004':

Application-defined or object-defined error

and suggests that the following line is at fault.:

Please Login or Register  to view this content.

Any help in getting the loop and date comparison to work well would be greatly appreciated!

Thanks for your answer. I changed row to currentRow and that did not fix it. I did some more checking to make sure and the Do Until loop works fine. It seems that the issue is the comparison of dates.

Thanks for the tip; I now checked the "Require variable declarations" box.

Also, I tried what you said and, it did not cause any runtime errors or anything but, it just did nothing. This leads me to believe that the date formatting may be an issue since I'm Canadian and my software may be either set up for the anglophone part of Canada or the US and I think the system I'm using is the French system (from the francophone part of Canada) for this Excel file.

Would you be able to help me with that?

I"m not knowledgeable about switching around localization settings in Excel (e.g., I don't know what is configuration specific to a file vs. specific to the installation of Excel), but I would be happy to at least take a look if you can attach your file.

If xladept's solution works it means that the data in your worksheet is stored as strings instead of dates.

Sorry for my late response but, the format was actually right all along. It didn't work because the test dates I put were wrong.

Is it running correctly just because my computer is likely set to "francophone Canadian details"? (I'm an anglophone but, I live in a francophone place and I have my settings set accordingly - in other words, my operating system knows I live in a french city but I chose American English as the language the OS uses to interact with me.) Is it possible that my VBA program will run in "American" or "Canadian anglophone" (or any other) mode if run on another computer with the exact same syntax?