Selecting sheet by codename in a multi sheet code

Hi - I hope someone can help me with this I've been trying different methods but i'm struggling a little

I'm trying to get a code to reference sheets by the codename - so in this case i want to start at Sheet18 and run the code through to Sheet37.

This is my code:

Please Login or Register  to view this content.

What it is dong is starting from the 18th sheet in the workbook (which is not Sheet18) because of hidden sheets and others before it.

I appreciate any help thanks
John

Simplest way...

Please Login or Register  to view this content.

Hi thanks for replying. I've added the code but its just running over on the same sheet. This is with my amendments:

Please Login or Register  to view this content.

Apologies - it does run through, it just doesn't do the:

Please Login or Register  to view this content.

bit on each sheet for some reason

Sorry, can't comment. Your amended code works fine for me... Copies the format from Cell B1 on Sheet1 to the other sheets.

Perhaps you need to qualify which sheet the range is to be selected on... As written, it'll select the cell son the current sheet.

Please Login or Register  to view this content.

to select those cells on the referenced sheet, ws.

(I need to refresh the page before posting...)

I just added

Please Login or Register  to view this content.