VBA Question...

[Woody75]

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

 

[JLGWhiz]

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

the VBA help file is a wonderful tool for things like this.

If ThisWorkbook.Sheets("Obs Sheet").Range("C" & Counter).Value <> Month(Date) Then

 

[Woody75]

Thx

 

[JLGWhiz]

You're welcome
Regards, JLG