Hi,
i wanted to right a vba that would delete the first row all all the sheets except 3 ("SynthesisVSD" And "BlackBerry" And "Table_Of_Content")
Here is what i wrote but i get a type mismatch:
i wanted to right a vba that would delete the first row all all the sheets except 3 ("SynthesisVSD" And "BlackBerry" And "Table_Of_Content")
Here is what i wrote but i get a type mismatch:
Code:
'Deleting first row
For Each Worksheet In ThisWorkbook.Worksheets
Namews = Array("SynthesisVSD", _
"BlackBerry", _
"Table_Of_Content")
If Worksheet.Name = Namews Then
With Worksheet.UsedRange
Worksheet.Rows(1).Delete
End With
End If
Next