Struggling to get the Loop to work

Hello everyone,

Imagine if I have more than one row with the current date. My macro works for one row but I want it to work for multiple rows, how can I fix it, here is the code.

Please Login or Register  to view this content.

The technical answer to your question is; after the first iteration of your loop the active worksheet is changed and the code within the loop incorrecly functions on the active workbook/worksheet.

Originally Posted by stnkynts

The technical answer to your question is; after the first iteration of your loop the active worksheet is changed and the code within the loop incorrecly functions on the active workbook/worksheet.

Perfect example of why you should avoid using Select and Activate!

Thank you for your reply, it looks brilliant. I'm getting an error though, here is the code:

Please Login or Register  to view this content.

It highlights Filename and says

Compile error:

Expected: end of statement

Any ideas?

ok, Replace this line:

Please Login or Register  to view this content.

with this line:

Please Login or Register  to view this content.

And see if that works.

This works

Please Login or Register  to view this content.

Thank you for alll your help

Cool, Glad I could help. Mark your thread as solved in the thread options. Cheers Lewis.