Looping through unkown sheet names

Hi All,

Searched and searched and couldn't find anything. Could you please help.

I've got this code below which looks at my data and when data changes in the row it grabs it all and adds a new sheet and pastes the data. Problem I have now is I want to format each sheet (the same way) but I don't know the sheet names so can't reference them. Is there anyway I can loop through uknown names and perform a code?

Please Login or Register  to view this content.

I've tried this code but it only seems to do it on the first sheet - but does it at the count of the other sheets.

Please Login or Register  to view this content.

Any help greatly appreciated

Thanks for the reply daffodil - but it didn't work either, does the same as my other code. Just does it for the first sheet. At the moment I've got 9 different sheets and it does it 9 times on the first sheet.

Any other thoughts?

It is in a module. I will try that code when I get back in the office, thanks

Also both the codes I use are in different subs, I use another to call them.

Sorry daffodil - pinkponies didn't work :P

failed at this

Please Login or Register  to view this content.

I'm not having any problems with this part of the code though. Once this part finishes its all good, it's the next part when I call

Please Login or Register  to view this content.

The bit that you have at the end of post #8 does not reference the worksheet(z) when selectin Range("A1:K1") so it will always reference the activesheet rather than looping through them. Try something like:

Please Login or Register  to view this content.

Thanks all for replying and helping me, I started at the bottom with Norie's and it worked a charm
Cheers!!

Yes mate, and the . Before the rows to, also made some other changes, just more formatting really. Thanks