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