print area

I think I've been staring at this code too long and I can't figure out why it's not working. I wrote this to dynamically adjust the print area to two sheets. The problem I'm encountering is when I have the sheet set up with two print areas already defined and I run this code to adjust it, I get...

I have a three sheet workbook that I created The first sheet is virtually blank it allows the user to cut and paste dispatch info, and customer info from Lotus Notes Dispatching which is then referenced to auto populate appropriate cells in Service Report(third sheet) The second sheet uses...

how to expand print area in excel 2007 example M colums.the file is below: http://www.mediafire.com/?vz4768tkgd31ubl

Hi All, I want to set a conditional print area via a macro run from a button and print<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <LI style="mso-list: l0 level1 lfo1" class=MsoNormal>It is to print in the <?xml:namespace prefix = st1...

Hello all, I would like to be able to update the page number in a repeating print area and have a single printout command to produce a single pdf file. The print area is fixed and I know the number of pages (3). There is a cell where the user can input the first page number to be used. Here...

I want to have two print areas (C11:D33 & G11:I33) print on one sheet of paper. Excel seems to want to put each print selection area onto a separate page. Is this standard behavior? I can't figure out how to do it. Please see below. Excel WorkbookCDEFGHI11ReforecastBudgetBudget$ Increase%...

Greetings coders! I have a problem. My workbook contains two sheets appropriately named Data Dump and Formatting. Within the Data Dump, I want to establish the amount of rows by using CountA("A3:A50"). For the sake of this question lets say there are 5 data rows. I want to set my print area on...

We are using a task list which has a fixed number of columns (A-F) but we are constantly adding rows. Since this is something which gets printed often, it's becoming annoying to keep setting the print area each time, not to mention there are some who keep forgetting to set the print area and...

I need to write a general function to set a border around each printed page, given a set of page breaks. The user will set his/her own print areas, and then the macro is required to format a border around these edges (exactly where the blue lines appear in page break preview. How do I access...

Hi, I am using the following code to set print ranges. I use this same exact code as part of another macro and it formats the pages correctly (it only uses the number of pages tall that is necessary). In a separate workbook, the columns format correctly in width, but there are extra pages...

Is there any non-macro way to ensure that the print area of a worksheet expands as more rows are added to a table? I can add a macro to do it but the file is shared by many and is large - people may not all know to enable macros and an on change macro might slow things up a bit. Any ideas or...

I am trying to make a report out of a bunch of data. I have about 80 columns of info that I want to show data for but it needs to be in a specific format. I want the first 8 columns of information to show up on every page (it has info related to the other columns that needs to be seen at all...

I am trying to set the print area to print only the area of the worksheet that contains text. Some cells contain formulas, so if you print the worksheet, 3 pages will be printed while only one may actually contain information. I created a named range 'MyPrintArea' (with the scope set to the...

Hi, I have a macro that someone very kindly helped me with on another thread (see below) I need this developed a bit more to include a page break at line 70, and also to specific what sheet to apply the whole macro to, i.e. their are 60 sheets in the book, but i only want it to apply this...

Hi, I need a macro to set the same print area over approx 50 sheets. Sheet 1, has the print area I want to replicate. The print area is A1:U190, the sheet needs to be printed on 1 page wide, by two pages tall. It must also page break at row 79. The sheets are say named Sheet 1 to Sheet 50. I...

I have been stumped with this, mainly because of the slightly annoyingly tight requirements :s Essentially what I'm trying to do is combine PrintTitleRows, PrintTitleColumns, Custom Print areas, and Scale to fit page. PrintTitleRows needs to stay at 86:91 PrintTitleColumns needs to stay as A:A...

I have a workbook that queries a SQL database and returns a different number of records each time. The query populates data from columns A thorugh J, however I'd also like to have an additional blank column print as well. My challenge is that I want to include this additional column, in this...

My father-in-law phoned me with an issue he is having with all of his Excel documents, old and new. Each document seems to cut off at column B when he prints or checks print preview. I walked him through how page setup works. I had him check the print area, and sure enough it was set to cut off...

Hi all, I have 2-ish problems. First, I want to create a format that shades every other line grey in my worksheet - however, Excel won't let me do that because I am using AutoFilters. It says they must be disabled in order to format what I have, but I cant afford to undo them. So, I thought...

My coworkers and I share a spreadsheet that we update often and save on sharepoint. Everytime someone wants to print the the spreadsheet, they have to readjust all the print settings (set print area, adjust to landscape, fit width to one page, etc.). Is there a way to save the print...