Is this not the proper way to check if the date in C is in the current month? It is deleting everything on the sheet.

rng4.Value <> Month(Date)