Hello MarkS,

StrComp does not returns boolean.
Try


Code:
--------------------

Debug.Print StrComp(Test, "Feb")

--------------------


The above code returns -1, True stands for -1 then printed "True".

In this case I would suggest you InStr function instead of StrComp
function as follows.


Code:
--------------------

If InStr(Test, "Feb") 0 Then
Debug.Print "True"
Else
Debug.Print "Not"
End If

--------------------



---
Message posted from http://www.ExcelForum.com/