process :Run macro on multiple sheets at once, not one after another

Dear all,

I would like to create macro for Page setup function by process all sheets in one time, not one after another too. I think this code nearly close with my problem. However, my worksheet name is not sheet1, sheet2 and sheet3. They have specific name in each worksheet. Could you give me VB code, please?
http://www.excelforum.com/excel-prog...r-another.html

This should do it ...

Please Login or Register  to view this content.

If you want to set other setup parameters, record a macro while doing what you want on one of the sheets and cut & paste that into the bit above within the "with / end with" lines ... Hope that helps. MM.

This code doesn't select the sheets, just does the Page Setup, thus it should run faster

Option Explicit

Please Login or Register  to view this content.

I realise the alternative code is more efficient, but the question was how to do this without selecting the sheets one at a time ... not that I understand what the reason for such a request might be But there you go - two options for you ..

The code I posted does not actually Select the sheets, it loops through them without and sets the PageSetup Surely this line actually selects the sheet?

Please Login or Register  to view this content.

Yep - you're right; I was trying to not loop through the sheets at all, but in creating the array, I've done that anyway ... point conceded