Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mango
 
Posts: n/a
Default search multiple worksheets name with common text and process using

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.




  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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

---
HTH
Jason
Atlanta, GA

-----Original Message-----
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.




.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"