Matt_Straya
Member
Hi, I have a sheet that has dates on it, displayed as days of the week. I am trying to get a macro to clear the contents of the column range from F7:F22 if F5 has "Sat" or "Sun".
What I have tried as a private sub clears all the cells, not just the column range under Sat or Sun.
Any ideas - Sheet attached
What I have tried as a private sub clears all the cells, not just the column range under Sat or Sun.
Any ideas - Sheet attached