Run Excel Macro IF certain condition is met, else exit Macro

[Martin Chamberlin]

This Macro works fine but I need it NOT to run if a certain condition is met.
When worksheet "Mileages" opens Cell I2 has todays date in it. Column J is a list of consecutive dates past and future.
Can someone modify the Macro so that it only runs if the date in Column J is a past Date.

Thanks in advance

Chambo

Please Login or Register  to view this content.

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Martin Chamberlin]

Thanks for the notice. Not sure if I have it right yet but I hit the # key as requested. Can you advise/help please.

[zbor]

Your post should look

Please Login or Register  to view this content.

Select code and then click # above.
CT.png

[Martin Chamberlin]

Sorted. Post edited as requested.

[zbor]

Date is in Column J or Column K as in the code?

[zbor]

Maybe this?

Please Login or Register  to view this content.

[Martin Chamberlin]

The date is in Column J. The Macro adds the date into J and also copies a corresponding value in Column K.

Where in the Macro do I add your code? Help is much appreciated.

[zbor]

It's new macro. You don't add in previous one.
If it doesn't work can you upload example workbook?
Make sure to remove all private informations.

[Martin Chamberlin]

File attached. Just hit the button in J1. Password protected safe

Thanks