Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Printing Multiple Sheets And A Range From Within A Separate Sheet

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I can use VBA to print an array of selected sheets. But I want to print 5 sheets (with preset print ranges) and two particular ranges of a 6th sheet (the ranges on this sheet change dynamically). This has to be done as a single print job (because its printing to a single pdf file). Any ideas?


Similar Excel Video Tutorials

Helpful Excel Macros

Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Print The Current Worksheet in Excel
- This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are currentl

Similar Topics







I print scores each week. Sometimes I print non-contiguous ranges on the same page (if there were multiple events that week.) When I just print one area the print quality is great, but whichever method I use to print non-contiguous ranges on a single page (and I believe I've tried them all) the print quality is noticeably worse.

Does anyone else have to do this regularly and, if so, do you have a technique that results in print quality comparable to regular Excel printing?


I have a file with many worksheets and I need to print some specific ranges in each of worksheet. Is it possible to set up a macro so all those ranges will be printed out in one click instead of going through all sheets and setting the print area?

I need to print out:
- Sheet 1: range A1:A25 (one copy)
- Sheet 2: first, range C10:F15 (two copies), then range H5:K10 (one copy). The two ranges should be on separate sheets.
- Sheet 3: range A2:F10 two copies
- Sheet 4: range A1:Z50 one copy. Actually, for that last sheet, the printing range varies every day because the range to be printed is a list of clients having placed an order on that day. So the list is more or less long depending on the day (A1:Z25, or A1:Z18, or A1:Z42, and so on...) A1:Z50 is the LARGEST range possible if ALL clients order on a particular day.

I hope I provide the right information so you can help me on that issue.
Thank you very much for your help.


I just started working with VBA recently and would like help printing different ranges within a single worksheet. The catch is that only ranges with data in a particular cell within each range needs to be printed.

For Example: Ranges A1:D10, F1:I10 and K1:N10 potentially need to be printed. Whether each range is printed or not depends on data being present. if cell A1 has data, print A1:D10 or if cell F1 has data print F1:I10 or if cell K1 has data in it, print range K1:N10.

If cell F1 has no data in it while cells A1 and K1 do have data I would still like it to print ranges A1:D10 and K1:N10.

Thus far I've only found the following code which gives a message box if nothing is available for printing or prints the entire active sheet if data is present. I haven't figured out what it is going to take to print the specific ranges based upon the specific cell data.


Sub PrintIf()
If Range("A1") = "" Then
MsgBox "Nothing to print"
Else
ActiveSheet.PrintOut
End If
End Sub


Please help!!!

Thanks,

Cory


I have a workbook with 4 spreadsheets, each taking 1 page to print.

I want Sheet 2 to print on the reverse side of Sheet 1 and Sheet 4 on the reverse of Sheet 3 so that all four pages of data takes 2 sheets of paper to print.

I have tried selecting 2 sheets at a time and 4 sheets at a time but printing result is always single sided even though "duplex" is selected in printer properties. In the Print dialog box I have tried selecting "Active Sheets", "Entire Workbook" and even "Selection". I've also tried specifying pages 1-4 rather than All. Eventually, by printing to a PDF creator, I have concluded that Excel is treating each tab is a separate print job. i.e. I get 4 separate PDFs.

I'm sure I've done this successfully before but I can't remember how.


Hello,
I'm trying print (via macro) multiple selections on multiple sheets. I have up to three ranges on each sheet, where each range (~4 printed page) is set as a custom view. The sheets are protected and I'd like to bring up the Print Dialog box if possible. I'm trying to add the custom views/ranges to an array in order to select all ranges and print the selection. Any tips on how to make this work or a better way to do this would be greatly appreciated. Thank you!!




I have a Document with multiple sheets in it and I ask it to print entire document which would be 7 sheets (1 Page printed per sheet) but only the first five will print, then it comes up with a second print queue that I need to use and OK to print the balance of them with. I'm printing To a PDF creation program. it saves and Prints the first 5 pages then asks for another new name of the document to save the next few pages. my PDF Creator works fantastic with any other program. I just need to know how to tell it to print as many sheets as I have to print without it doing that. so I can print all sheets in a single PDF document.



I have a Document with multiple sheets in it and I ask it to print entire document which would be 7 sheets (1 Page printed per sheet) but only the first five will print, then it comes up with a second print queue that I need to use and OK to print the balance of them with. I'm printing To a PDF creation program. it saves and Prince the first 5 pages then asks for another new name of the document to save the next few pages. my PDF Creator works fantastic with any other program. I just need to know how to tell it to print as many sheets as I have to print without it doing that. so I can print all sheets in a single PDF document.

I select three consecutive sheets in a workbook and print to the adobe 9 PRO print driver to create a pdf of the three sheets.

I always get two pdf's out of the process. The first selected sheet prints as a pdf file and then the remaining two sheets print as one pdf file. I'm left to combine the two pdf's into one pdf which is what I would have expected excel to do to begin with...print all three sheets to a single pdf file.

Anybody know what is causing this???

Thanks!


Hi All,

Can the experts please help diagnose this problem - I have an excel file which we use to print meeting minutes on each day. We select four worksheets and print them to pdf. For some reason, excel has stopped being able to manage this task on one go and tries to print the worksheets in two or more batches (ie, sheets 1, 2 and 3 in one print and sheet 4 in a separate print). This is fairly annoying because it means we have to try and combine the two separate pdf files.

It's not just the pdf though as the same thing happens when printing to a normal printer. If you select the four sheets (1 page print each), it will print the first three together and then print the fourth sheet separately.

Any ideas!

Graeme.


I'm trying to find a way of printing multiple worksheets at one time (my goal is to save them as a single pdf file from the print menu). I know how to select multiple sheets and then print, but this results in multiple print jobs or pdf files. Would it make sense to create a new worksheet that references all of the other sheets in sequence? When I've tried this, I've had some problems maintaining the correct formatting in the new sheet. I would, however, like to keep the ability to modify individual sheets (this helps manage the 15-20 pages of data and graphs).

Any thoughts?


Hey everyone. I have a problem. I've searched the forum, and couldn't find an answer to my question, so I figured I'd go ahead and post it.

I need to print multiple sheets from a single workbook (that have appropriate print areas already set up). I want to assign this macro to a button, so that I can just click one button and get a copy of every sheet.

Each of the sheet names is unique, and stored in column A on a sheet titled LIST, since there are four sheets of stuff that don't need to print. Each of the uniquely-named sheets are hidden as well. What I need:

* Print all sheets, using the names on LIST in column A (A1 to the last one with data; the names are alphabetized from ADAM on down to WILLOW).
* Ask for confirmation 'Are you sure you want to print all saved sheets?'
** If yes, print all the sheets.
** If cancel, do nothing.

Any help would be appreciated. I can see how Id do everything but using the A column to define what names to print, I think.


I am a continuing Computer support specialist and I am having a very rough time with excel and their print/print preview events. I am required to set up a User Form with a multi-select lstbox and two cmd buttons one for printing and one for exit printing. When a user clicks on the icon in the file menu for print or print preview the code for the BeforePrint event is fired. This action loads the lstbox with all sheets in the Workbook and then displays the User Form. The user can then select which sheets to print out or preview. One major problem I am having with it is the fact that the PrintOut method triggers the before print event. One more thing, when the user selects sheets and clicks print sheets cmd btn I am to Print the selected sheets and set their footers to match the sheetnames. Please help if you are able to. And Thank you very much in advance!!



I have a workbook of 10 sheets in excel 2003. I did set for every sheet a print setup duplex. I even set a print area for each sheet. But when I print from sheet 1 to sheet 10, some sheets come out as double printing , a few sheets go single side printing. Why? when I set a print area, should this area be exactly a page lenght?


Need a little help. I am currently working on a spreadsheet that is fairly simple in all regards except the print ranges. I have 3 main goals I need some help to achieve:

1) I want rows 1:250 to print based on 2 conditions:

a) It includes a minimum of up to row 28 to include the category totals. And truthfully row 28 may increase if the end user decides to add more categories.

b) Cells B7:B250 contain a value > 0.


2) I want E6:G28 (Summary of Totals) to print on every page view. Much like a print title.

3) There will be a total of 12 sheets (Jan, Feb, Mar, etc) per workbook. All sheets need the same print range conditions.

Currently it is printing 7 pages total. I think this is because I have an IF statement in the Date field that returns a "" value the condition is false.

Can someone out there please help with this? It is most appreciated.





I have a workbook with 4 spreadsheets, each taking 1 page to print. I want Tab 2 to print on the reverse side of Tab 1 and Tab 4 on the reverse of Tab 3 so that all four pages of data takes 2 sheets of paper to print.

I have tried selecting 2 tabs at a time and 4 tabs at a time but printing result is always single sided even though "duplex" is selected in printer properties. In the Print dialog box I have tried selecting "Active Sheets", "Entire Workbook" and even "Selection". Eventually, by printing to a PDF creator, I have concluded that Excel is treating each tab is a separate print job. i.e. I get 4 separate PDFs.

I'm sure I've done this successfully before but I can't rmember how.


I have a worksheet that has multiple print range. I would like to put a condition in that stops one of the ranges printing if a cell on a sheet has a certain value. Hope you can help


Hi, I have written a macro to print a succession of named ranges. The named ranges border one another. This seems to lead to the ranges (which I want printed on separate sheets) to merge into one, leading to them NOT being printed on separate sheets. How can I avoid this? I know if I leave a single column gap between the ranges this does not happen, but the way I have already organised my spreadsheet, this is going to be a mammoth task now. Any way round this annoying and unexpected quirk?
Thanking y'all in advance.
Nigel Foster


I have a workbook that has a total of 44 tabs; tab 1 = 'Summary' and then 'T1' through 'T43'

When I go to print the workbook, I do what I always do with other workbooks: I select all sheets and hit Print. On this workbook, tabs 'T15' through 'T43' print first, and then 'Summary' through 'T13' print. Tab 'T14' does not print unless I print it separately from the rest.

I am not using any code to do this printing. I am right-clicking on a tab and selecting all sheets and then using the standard Excel toolbar or File...Print menus. When I view it in Print Preview with all sheets selected, T14 is there and looks fine. There are no extra page breaks that I can see.

Has anyone else experienced this or does anyone know what is causing this?

I would appreciate any help that can be offered.


I'm trying to print two sheets within the same workbook at the same time as a single print job. This way sheet1 is the front and sheet2 the back.

It I do select both sheets and then print active sheets Excel creates two print jobs, forcing the printer to start the second sheet on a new page.

This page break between the prints means that I have two single sheets printed out of the printer rather than one piece of paper in duplex.

Any ideas on a work around for this?

The two two sheets are only a sinlge page in size, but have different column widths so wont easily go onto a single worksheet.


I have a large excel file with several data prep/manipulation macros in it. I have defined ranges, multiple sheets, and one or two arrays. My problem is that when I print (no matter using selected sheets or entire workbook), the one print job separates into many. To be exact, a new print job per sheet. This is causing me problems in converting to Adobe. I'm relatively new to programing, but are there any elements in VBA that would make my file do this? Or is there any code I can use to keep all of these sheets together?

Please help.




I know there are many threads out there similar to this one, however, I have not quite found one to fit my situation. With my limited coding skills (self taught out of necessity), I am challenged on this one. I have code that creates a dialog box for the users to select which sheets to print (workbook sheets can change). This works great and adapts as sheets are added and prints to the printer just as designed. However, I now need to be able to do this same thing but print to a PDF - I can get it to print each selected sheet individually to a single PDF, but need it to not only print to PDF, but to consolidate the selected sheets into a single PDF file.

I have attached my original code that prints to a standard printer. Any help on taking this in a new direction would be greatly appreciated. I apologize in advance for my non-technical background!

Thanks.



Please Login or Register  to view this content.



Dear Friends,
First of all thanks to all of you for the support provided so far. I have stucked in at abottom place for which I need your precious help.

I have a Work book (Say X). Three of the sheets (Say Sheet10, Sheet 11, Sheet 12) contains the data from which I need to print a range of cells. Let the cell range be A5 to R70(May be different for different sheets. In the range most of the rows do not have data as they are made for inclusion in future. The rows in the selected range may have data in random. So I want to Print the data excluding the rows do not have data or have zero values .

I need to print the sheets seperately with option button selection for the three sheets. The print range may exceed one page in each sheet. So I should be able to see the option for printing as like a normal print method we get in MS Office print options. Also I should be able to see the page print preview of the selcted sheet and printer selection & page set up window as we get in normal day to day printing before print from which I can select the pages and authenticate print.


Thanks.

Regards,
nm766



I have a spreadsheet that has multiple sheets that I have programmed multiple print option macros. Each sheet has three print option macros: 1 to print all pages in the sheet, another will print only the last two pages (the scorecard) of the sheet, and a final one that will print only the first page (the smart goal) of the sheet. I have consistently named the macros for each of my 15 sheets (PP_DF1, PP_DF2, etc. to print all pages, SC_DF1, SC_DF2, etc. for printing the scorecard, and SG_DF1, SG_DF2, etc. to print only the smart goal).

On my Print Options sheet, I have a data validation that I have used the name reference of "printchoice" where the user will select the sheet name they want to print. There are then three buttons - one to print all pages, one to print the scorecard, and one to print the smart goal.

I also have a table on the same Print Options sheet that lists the Sheet and then the three macros associated with that sheet so that I can use vlookup. The table looks like:

SHEET PRINT ALL SCORE CARDS SMART GOALS DF1 PP_DF1 SC_DF1 SG_DF1 DF2 PP_DF2 SC_DF2 SG_DF2



I know that I should be able to do this with a sheetchange event, but I don't want the macro to run just when a user selects the sheet they want to print. I want them to choose the sheet, then click the button that identifies what pages within the sheet they want to print.

Everything in my sheet is named - I'm a bit OCD about naming ranges and cells and tables!

So if you can let me know how I should program this, I would really appreciate it. I've tried a few things I saw on other posts, but I'm just not getting it somehow. ARGH!

FYI - the file is over 2 MB, so I can't upload it in its entirety. But this is a word document that has some code and images of what I'm trying to do.
print options macro help.docx

Hi there,
I have a spreadsheet with multiple sheets containing colour formatting
(including graphs) that is regularly printed out in colour and greyscale. The
problem I have is that when I need to print out several sheets simultaneously
I uncheck the "Greyscale" option under print options and have the print job
come out in colour. To print multiple selected sheets in colour I need to
change the print options for each individual sheet (about 10 in all) to
colour (non- greyscale). One strange peculiarity of this is that some of the
sheets will not need to be "Unchecked" whereas others will. They are not
necessarily the same sheets each time either.
Unfortunately due to page numbering I cannot print out each sheet one by one
either.
I have the reverse problem when I want to print in Draft in Greyscale.

Can someone help me? Is the colour status controlled by the sheet, the
workbook, or the printer? Can anyone suggest a solution?


Thanks for you help,





Is it possible to set up several print ranges on one spreadsheet. These print ranges are of various sizes and various page layout print settings.....also, can a macro be applied to print all at once?