Quote:
Originally Posted by macropod
Charles' issue was with finding the month via its formatting, using VBA.
|
True! But unnecessarily complicated! Really his task was comparing dates on 2 sheets:
Was there a 1st of month in other sheet from same month as month of checked date?
Or (which option is right one remains unclear) was there a any date in other sheet with month same as month of checked date?
Using formats for it was only his way to do it! As result he got an issue :-)