VBA if or statement

[trebor1956]

I have a macro as follows:
Sub selecttoday2()

For Each cell In ActiveSheet.Range("A2:NT2")
If cell.Value = [Today()] Then
cell.Select
End If
Next

End Sub

It currently says "Date not found" if it can't find the date.
It works fine but I want it to say "Not current year" if todays date is not found please.

Many thanks,

 

[jasonb75]

There is nothing in the code to show a message of any kind, if it is showing "Date not found" then that must be done in some other code.

You just need to find that in your code then change it to the message that you want in its place.