Excel-VBA

Question

Hi Guys I want to find sheet name in excel vba with prefix name like bYYYYMM(e.g-b201308). how to write and help me.

Ye Htut · Answer

Private Sub cmdfind_Click() Dim ws As Worksheet For Each ws In Workbooks(SampleDataForMeter_2.xlsm).Worksheets If ws.Name = Format(Now() b & YYYY-MM) Then MsgBox OK End If Next ws End Sub it doesn't work