Hi Barry,
It is usually easier and faster to just try to do something
and then catch the error with the on error condition, but
the main thing is that you are considering the not so remote
possibility of a duplicate sheet name.

Suggest you do NOT use mmm-dd format for the sheet names
because they won't sort in order if you sort the worksheets.
http://www.mvps.org/dmcritchie/excel...#sortallsheets

Suggest formatting as yyyy-mm-dd or a little shorter as yyyy_mmdd

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barry Wright" wrote in message ...
Ok, I agree with you now. You and all the others posting on this
link.....I need to check duplicate Sheet names.