fiirst of the month clear cells

I need a code that if it the first of the month then clear the cells, but only on a button click
joshuajoseph09Asked:
Who is Participating?
 
TinTombStoneConnect With a Mentor Commented:
This clears the entire sheet
If you just need to clear a particular range then change it to

Range("A1:D100").Clear

Assign this to a button or the QAT dpending which version you are using

Sub ClearCellsOnFirst()

    If Day(Date) = 1 Then
        Cells.Clear
    End If

End Sub
0
 
patrickabCommented:
What is QAT ?
0
 
TinTombStoneCommented:
In Office 2007/2010 it is the Quick Access Toolbar
0
 
mlmccCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.