Hi
change the line
if lcase(wks_1.name) <lcase(test_value)
to
if lcase(left(wks_1.name,3)) <lcase(test_value)

--
Regards
Frank Kabel
Frankfurt, Germany


Thanks, you have me in the right direction... But, what if my
worksheet is called 101NOW and 101-MAR

How can I have it just check for the 101 in the worksheet name?


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