This slightly different approach will test if almost any date format has been used and properly identify them all, even if they differ:
12-12-2012
1-1-11
May 2012
![]()
Sub NameTest() Dim ws As Worksheet For Each ws In Worksheets If IsDate(CStr(ws.Name)) Then MsgBox ws.Name Next ws End Sub
Bookmarks