Hello all,
I am trying to tell a cell to hide if the date in the cell is equal to the first of the month.
I am struggling with the code to check if the cell is equal to the first of the month.
Here is my
Can one of you fine forum please help with the date value calculation?
Friendly Regards
Herman
I am trying to tell a cell to hide if the date in the cell is equal to the first of the month.
I am struggling with the code to check if the cell is equal to the first of the month.
Here is my
Code:
If DateValue(Date("yyyy/mm/01")) = DateValue(Range("A32")) then
Selection.EntireRow.Hidden = True
End if
Friendly Regards
Herman