Hello Tom,

If you are only checking the last two characters of the string, you ca
test it this way.

If Right(Test, 2) = "00" Then Result = True


Hope this helps,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=34660