Macro across all worksheets

[ryn]

Hi.

I've written a macro in excel that applies some formatting across a spreadsheet. What I now need to do is to apply that formatting across all the spreadsheets in a workbook when there are different numbers of spreadsheets in each workbook.

I've different approaches to this so far using for...next and for each...next but all these do is loop the same format onto the first spreadsheet and leave the others untouched.

Does anyone know how to make it move from spreadsheet to another when the number of sheets in the book is unknown?

Thanks.

[Carim]

Hi Ryn,

Dim WS As Worksheet

For Each WS In ThisWorkbook.Worksheets
insert your code
Next

HTH

Cheers
Carim

[ryn]

Thats what I have tried so far and it doesn't want to work.
I've included the code that I've got so far but when I run it, it only runs on the sheet I currently have active and ignores the inactive ones.

Please Login or Register  to view this content.

[jtp]

Place WS.Select in the line below the For loop. If you dont want to see all the screens bouncing around. Type Application.ScreenUpdating = False in the line above the for loop.