Macro to Format

[cSciFiChick]

So at my job before I send reports they have to be formatted a certain way. And it would be awesome if I had a Macros that when through all the tabs and formatted them for me so I don't have to do it on each tab.

First the data has to be scrolled all the way to the top and the cursor needs to be in A1. Then we need to sent the print area. So I click on the box in the upper left to highlight the whole sheet then I do Print Area > Set Print Area. The reports are in tons of different sizes so a standard size does not work it. Then the margins are a special which is like top .15 sides .22 etc dont know exact off the top of my head because I am not at work

So is there a Macro that could do all of this?

 

[Fluff]

So is there a Macro that could do all of this?

Yes there is.
The best thing to do is record a macro for one of the sheets and then post that code here.
Then, hopefully, someone will come along & modify that code to do all the sheets.