Michael,

If your sub is called MichaelsSub, then

Sub AllSheets()
Dim mySht As Worksheet
For Each mySht In ActiveWorkbook.Worksheets
mySht.Activate
Call MichaelsSub
Next mySht
End Sub

As long as your sub works on the activesheet, and is written well, that will
work. Post your code if things are otherwise.

HTH,
Bernie
MS Excel MVP

"Michael" wrote in message
...
I am trying to clean up some data and I need to search about 20 tables
(which
I have copied down to spreadsheets) and Identify the lines that contain
one
or more of these special characters.

I have not been able to put all the components together in working
fashion.

I plan on just doing them one at a time. I have been using a SUB() for
just
the active sheet and running it on each sheet individually. This would be
just fine if it worked.

thanks for any help.