Perform operation if today is the first of the month VBA

[LambChoptheKid]

Hello, I'm building a macro that will perform a data pulling operation each day when I run it. This part of the macro runs great. But, at the start of each month the data should be scrapped and the data storage worksheet should start again from zero.

The idea that I have is to bracket my function in an IF statement that checks to see if today is the first of the month and if it is, then delete data in rows 2-1500. I imagine that the delete function will be easy to work out on my own, but I am a bit lost as to how to see if today is the first of the month in VBA language.

Does anyone have any ideas or experience regarding this kind of thing?

Any help is greatly appreciated!

This is in Excel 365 btw

 

[MARK858]

One way

If Date = DateSerial(Year(Date), Month(Date), 1) Then

 

[LambChoptheKid]

One way

If Date = DateSerial(Year(Date), Month(Date), 1) Then

This worked wonderfully, thank you!

 

[MARK858]

You're welcome