search multiple worksheets name with common text and process using

M

mango

dear all, hope can help.
i need to process a list of worksheet with the common name.
for example i will search through all the sheets and when found the sheet
name carries "AMT" the vba will process the sheet. they are not in sequence.
can show me the sample in vba?
thanks alot.
 
J

Jason Morin

Something like:

Sub WorkAMT()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name Like "*AMT*" Then
<<<your code here>>>
End If
Next
End Sub
 
Top