PDA

View Full Version : Activate sheet which contains date



shamim
05-20-2019, 10:14 AM
Hi,

How to identify/Activate sheet if contains date (mm.dd.yyyy) in current workbook?

Regards,
Uday

Bob Phillips
05-20-2019, 11:49 AM
Private Sub Workbook_Open()
Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets

If IsDate(Replace(ws.Name, ".", "-")) Then

ws.Activate
Exit For
End If
Next ws
End Sub