Hey all,
I am just trying to sort out some code which needs to trigger between different halves of the year. It does not matter what year or day of the month. Any date before 31 June trigger one way and any date after 1 July trigger another way. I have tried many different versions of date and Month but cannot get it to work.
Cheers,
Milos
I am just trying to sort out some code which needs to trigger between different halves of the year. It does not matter what year or day of the month. Any date before 31 June trigger one way and any date after 1 July trigger another way. I have tried many different versions of date and Month but cannot get it to work.
VBA Code:
If "todays date = June or less" Then ' first code goes here
If "todays date = July or more" Then 'second code goes here
Cheers,
Milos