Question

怎样统计带“班级”二字的工作表个数?

Answer 1

先前那个宏改一下就行啦

Sub aa()

For Each st In Sheets

If st.Name Like "*班级*" Then n=n+1

Next

msgbox n

End Su