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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ye HtutPosted Aug 18, 2013, 11:15 PM
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