print area

Hi, I am trying to combine two print areas and have them print out one after another as if there was no break between them on the spreadsheet. My problem is that the first print area which is only 1 row is being given a whole page. Here is my current code: (top= 10; bottom = 153) Function...

I need to find the final column and final row numbers for a dynamic print area from worksheets in different workbooks so that I may properly define the limits for my For Next loops. The usual method of using Cells(Rows.count,1).End(xlUp).Row or Cells(1,columns.count).End(xlToLeft).Column will...

I have a worksheet that's formatted to print out on a long, 1 inch-wide strip of adhesive label tape. The range of potentially printable cells goes from A1 to CF6. All of the cells in this range have conditional formulas in them to either pull criteria from another sheet in the file, or...

Hi, I'm using Excel 2007. In my workbook I have a worksheet. In this worksheet I have two separate regions that I would like to print. Let's say they are A1:B2 and C3:D4. I go to print break view. I then select those regions, right click and choose set print area. Everything beside those two...

Hi everyone, I would like to request some help with the following problem. I would like to use some code to set a non contiguous print area using columns A to E and K to AE. The number of rows is determined by finding the last row used. Here is the code I am up to at the moment: Sub...

Hi, In either VBA or done manually is it possible to instruct the printer to print the document so it stretchs it to fill out the entire sheet of paper (less margins?) If so, what might be a good way of doing this? I have a document that is leaving a good amount of blank space on the paper...

Hi, Could you please help me with a macro that will set the Print Area of a report based on the current lenght and width. I have found macros that will set the Print area for reports of variable lenght but nothing for variable width. I would love to be able to run the macro on the Active...

I have a workbook containing a sheet that lists several possible line items in a price quote, and a pivot table containing those items selected by the user to be displayed (using checkboxes and a report filter). I want my users to have to do as little as possible to go from selecting the rows...

Hi, I have a database i've been working with and today I went to print the sheet and noticed that the sheet had many many blank rows. So when I went to print the table would not fit to the page correctly. Is there a way to re-format a sheet so that it eliminates all the extra blank rows?? I...

Happy Friday Excel Wizards! There are similar posts on the boards but I haven't found one that quite gets me to where I need to be and I am getting desperate! What I want to do is have a userform that includes checkboxes and upon selection of the checkbox, it will print the quote for the...

Hello there, I've a very large spreadsheet with a large diagram and a lot of data. Is there a way to write a macro that selects the printing area as viewed on the computer screen? Many thanks

Hi, I want to create a macro that will print a specific print area. The problem is that my I have different orientations. For instance: in one of my spreadsheets I need to print the first five pages as portrait and the following 3 on landscape. Is there a macro for my problem?

Hi, I have seen some posts regarding dynamic print ranges, but I have not been able to find quite what I need. So here it goes: Problem Description: I have an application where I allow a user to select from a list of "reports" on a form. Each report is on the same worksheet, so say 5 reports...

I have determined how to set the print area of a sheet. psActivePage.PrintArea = UserRange.Address But I can't figure out how to get what the current print area range is once it has been set. I would think this would work, but it gives an error. Set rPrintArea =...

Does anyone know how to eliminate the print area of a tab so that the tab is visible (i.e., not hidden), but so that none of the contents of the tab print? We have tried removing the cells from the print area and clearing print area, but it just springs back automatically. Any thoughts would...

Ive a file with multiple worksheet and trying to set print area for all worksheets at once (grouped). This macro posted by Juan Pablo works fine with one sheet but when I group the worksheets this macro doesnt work. I would like to set print area when the worksheets are grouped so I can run the...