delete rows across multiple tabs

[JamRivera]

Ok so I am still a little new to macros so be gentle and please help it will be greatly appreciated.

I have a macro and I want to delete any row that has the following text in a cell ISN or MTS across 35 tabs. current macro is only deleting ISN and MTS in active sheet.

Sub Delete_Rows_ISN3()
Dim lRow As Long
Dim iCntr As Long
lRow = 390
For iCntr = lRow To 1 Step -1

If Cells(iCntr, 3).Value = "ISN" Then
Rows(iCntr).Delete
End If
Next
End Sub

 

[MARK858]

You should find that the other code that I posted is much faster than the code that you have just amended