I want to clear all other hyper linked texts or sentences if existed in used range of each sheet except x,y and z.
Sorry for the post title.
Sub addtext1()
Dim ws As Worksheet
For Each ws In Worksheets If ws.Name <> "x" And ws.Name <> "y" And ws.Name <> "z" Then
Your CODE
End If
End If
Next ws
End Sub
Bookmarks