print area macro help

Hello, I am trying to create a code to automatically select the range (that can vary horizontally) and print it. I tried to use this code, but it prints only 1 page regardless the amount of pages needed to print all data in range. And I don't even understand why it limits it to 1 page. Sub...

Guys, I am New to this forum. Appreciate your any help in my below issue: I am receiving 200+ emails in outlook everyday as PDF attachment. All attachments are protected with known and Same Password. Is it possible to create VBA to Print all these on Daily Basis? Currently I have to open each...

Hi, I have a worksheet where I want to print Cells A1:M36 in Portrait orientation but then also print cells A38:A69 in landscape orientation. I cant seem to be able to do this through normal measures so would anyone have some code I can use to do this instead? thanks in advance

I have a file that contains 25 worksheets w/ all same formatting. Now, I need to set the print area to A1:N58 for sheets("firstone") and set the print area to A1:N40 for sheets("secondone"). I only know how to do this for 1 worksheet (activesheet) at a time. Below is what i used...

Using this code to export multiple worksheets to PDF, how can I adjust the PDF zoom that the PDF will open up to? Manually creating the PDF does this for you but the macro doesn't. Can anyone help? Sub PDFPages() ThisWorkbook.Sheets(Array("Front Page", "Page", "Last")).Select...

Hey Guys/Ladies, My code currently selects a set number of Named Ranges to print.. It prints everything. Even zero totals..aaargh. I need help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ". Sub PrintCDivSum() 'error trap added for...

Hey Guys/Ladies, My code currently selects a set number of Named Ranges to print.. It prints everything. Even zero totals..aaargh. I need help getting VBA code not to print "Ranges" in worksheets where the "Total" any given table is " 0 ". Sub PrintCDivSum() 'error trap added for...

I have an excel document with 10 tabs. The first two tabs print 11x17 and the remainder print 8.5x11. When I print the entire document, how can I make it so the first two tabs print on 8.5x11 front and back? I want it to print like this every time. Is this a macro?

I have a list of products that I have employees use as a reference sheet to confirm they are picking the correct item # in our shipping department. The sheet is set up as column A - item # column B - Item name column C - Small picture of item column D - how to package the item As I need to...

Greetings Lovers of Excel, In making my label printer, I will need to set the print area for multiple sheets based on a range generated in a cell. E.g. Sheet1 might need cells A1:P1200 set as print area, Sheet2 might need cells A1:G694 set as the print area, Sheet3 might not need to be...

Hi forum goes, Need help on the following code. I pieced this together from other posts. I am trying to get this long print range to only print the sections that have information to print, if the next section does not have printable information, it should move to the next section until it has...

Hello All, I have a worksheet containig 12 different charts. I have created a print button that brings up a user form that contains a check box for each chart name. Depending on which charts the user wants, they are to check the box next to each desired chart. I am needing a print macro...

The Question: Does the "PrintArea" Property require an A1 style reference? The Problem: I am using a macro to generate a report. I have the report macro handled. It generates a 4 column table that starts at A3 and ends at D42. Once row 42 is reached the macro starts at E3 and continues...

Is there a print "if" function that would recognize text values and print the page instead of manually changing the page break each time. Background : I am creating a generic template for journal entries and trying to include additional notes as needed. I have added an outlined box to include...

Hi all, First time posting so sorry if I miss out info you require. I am working on some bank ledgers in excel, some of which date back to 2005. These are updated by the bank weekly and forwarded to me. I was wondering whether there was any way in which to automatically sift out the...

I have a worksheet with billing information. Column A (A6 and down) marks whether an invoice has been entered (= 1) or not (=-1). There are also codes "-2" and "0" (zero) From the beginning there are 2000 rows of "-1" in this column. This is safely over the maximum number of invoices in a...

<TABLE border=0 cellSpacing=0 cellPadding=2 width="100%"><TBODY><TR><TD align=left>I have a Data Validation Box in Cell E7 Worksheet "Report" that references the employees numbers in I3:I80 in another worksheet "Data". I can select the employee numbers from the Data Validation box & it will...

Hi I have been having a problem trying to create a macro that sets the print area of my document by looking for the text Grand Total in Column A and the text Grand Total in Row 7. The sheet I will be using this on is created by an export from our server. Any Help would be greatly appreciated