Does anyone know where i'm going wrong with this??
If ThisWorkbook.Sheets("Obs Sheet").Range("C" & Counter).Value <> (=MONTH(TODAY())) Then
I'm not sure how to make VBA use the excel MONTH command, thought i'd see someone in the forum do it that way before.
Any help would be great
If ThisWorkbook.Sheets("Obs Sheet").Range("C" & Counter).Value <> (=MONTH(TODAY())) Then
I'm not sure how to make VBA use the excel MONTH command, thought i'd see someone in the forum do it that way before.
Any help would be great