Hi all, newbie on vba here, if cell value is current end-of-month how to clear cell contents?
This is for a column full of dates.
For range AF2:AF
If cell value =EOMONTH(TODAY();0)
Clear Cell Contents
or
For range AF2:AF
If cell value = AE2
Clear Cell Contents
Cheers
This is for a column full of dates.
For range AF2:AF
If cell value =EOMONTH(TODAY();0)
Clear Cell Contents
or
For range AF2:AF
If cell value = AE2
Clear Cell Contents
Cheers