Two more string functions that I find useful a

'For what you are looking for
If Left$(ActiveSheet.Name,3) = "CWR" Then

It's related funcion is Right$. I know that these are supported through all
versions of Excel VBA I have worked with, up through 2003 as carried over
functions from the days of DOS Basic. I believe that you can leave off the
$ but I use it as a habit from the old days.

David

"Casey" wrote in
message ...

Alan,
Thanks for the reply. If you look at the entire thread; I got the
answer I needed, however I think your reply may help with another
problem I have with a different project. Thanks again.


--
Casey


------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=562204