Change thisworkbook to activeworkbook assuming that the book you want to loop
through is the active book...

For Each ws In Activeworkbook.Worksheets

--
HTH...

Jim Thomlinson


" wrote:

Not really
I think it is trying to work but I have two different spread sheets
open and it is trying to cycle through through the wrong one