Hi,
In my job I quite often need to print out excel workbooks containing numerous worksheets. They are rarely formatted print ready and so I have to go into each tab and do print preview, page breaks, make sure all text within the worksheet is selected within the print area etc.
Is there a macro that could do this for me for the whole workbook?
Thanks for any responses.
Are all worksheets formatted the same, use the same page breaks, etc?
Yes, you can loop through the sheets and apply any formatting or page breaks you want.
Since you don't provide enough details about the workbook/sheets, you can start by recording a macro to apply the formatting and setting the pagebreaks, etc. to a single worksheet then post the code and workbook for further help.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thanks for replying.
Each worksheet would contain different amounts of data, some may fit onto one page where as the next may contain a huge list that would fill 100 pages.
I guess I'm looking for something that would do the following;
Go to first worksheet
Select a cell range that covers all cells that contain values
Set this selection as the print area
Then move onto the next worksheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks