I have a workbook with 100 or more worksheets, many of which are very short. I wish to print the entire workbook but without a page break between each worksheet. Using Excel 2007.
I have a workbook with 100 or more worksheets, many of which are very short. I wish to print the entire workbook but without a page break between each worksheet. Using Excel 2007.
welcome to the forum
I am not aware of a way to do what you want without VBA
Below is a VBA solution which will give you what you want if column widths match up in all sheets
I cannot think of a way to achieve what you want if column widths differ between sheets
VBA solution
- create temporary worksheet
- copy every sheet into temporary sheet (one below the other)
- print that sheet
- delete that sheet
Put in general module
Please Login or Register to view this content.
EDIT - I added the line Exit Sub so that you can look at the results in temporary sheet while testing
Last edited by kev_; 07-07-2017 at 03:11 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I have set all the column widths to match. ie all column A's are the same width, all column B's etc. Then I ran the macro above but it only copied a few rows here and there and missed 99% of the data. Any idea why?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks