for each sh in Activeworkbook.Worksheets

might be what you are looking for.

--
Regards,
Tom Ogilvy

"Michael from Austin" wrote in
message ...
I have a macro that I want to have also run on the next worksheet and then
the next until there are no more worksheet. The worksheets have names. I
do
not want it to have to look for the name and then open it. I just want it
to
go to the next one and then the next until the end... Can this be done.
Any
help would be appreceited.....
--
Regards,
Michael