Macro with muliple tabs - works on some ss's - not on others.

[ds0919]

I have a macro that I plan to use each month on a P & L spreadsheet. The P & L is in the same format each month and has multiple tabs (we own retail stores - so one tab per store) When I run the macro on older reports (Sept 2012 , Oct 2012, Jan 2013) it works on one of them, but not the others. The format below only works on the first tab on a couple of the P & L's - on the other P & L it works fine on all tabs. I am baffled and to why it isn't working on all tabs on all P & L's. Any suggestions? Do I need to run the commands for each tab separately?

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

only looks on the active sheet, you need to loop through the sheets

[ds0919]

Can you offer a suggestion as to how I need to modify?
Can I just remove that line "with activesheet.pagesetup" ?
I am new to macros and am trying to learn.
Thanks!!!

[AB33]

Untested

Please Login or Register  to view this content.

[ds0919]

Thank you AB33!!!!