Something likeDim lastWFWorksheet as Worksheet Dim countOfWF as Long Dim oneSheet as Worksheet For each oneSheet in ThisWorkbook.Sheets If oneSheet.Name Like "wf*" Then countOfWF = countOfWF + 1 Set lastWFWorksheet = oneSheet End If Next oneSheet ' ... MsgBox CStr(countOfWF) & " sheets names begin with wf (case sensitive)." ' ... If countOfWF <> 0 Then ThisWorkbook.Sheets.Add after:=lastWFWorksheet End If