Excel VBA判斷工作表是否存在的函數 | 彰化一整天blog

Function checkSheetName(sheetname) '檢查活頁是否存在 isfind = False For Each st In Sheets If st.Name = sheetname Then isfind = True Exit For End If Next checkSheetName = isfind End Function

wordpress.bestdaylong.com