print area definition

  1. L

    Maintain a Print Area even when rows or columns are deleted

    I am looking to set up a Print Area on a sheet that will remain even when I delete columns. Currently my print area is A1:G24 and when I delete columns A and B, my print area becomes A1:E24. I would like to set up the print area so when columns within that range are deleted, the data that moves...
  2. J

    Quote Workbook Help

    Hi All, I am new here so if I ask a question that has been posted before please feel free to point me in the right direction. I have reached a point in my workbook where I am going to be needing some serious help, non of this google searching, saying that it has lead me here many a time and I...
  3. A

    Getting VBA in Excel NOT to print certain ranges where Total is = 0

    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...
  4. R

    Print marked area, adapted to one page

    Hello, I wonder if anybody out there can help us out at our workplace: every so often, we need to print work schedules from Excel, to get it right we have to: 1. Mark an area in a Excel-page 2. print that market area - vertically - adapted to one page It's a little tiresome to do this in...
  5. C

    Printing mulitple PDF files

    Windows 7 - Excel 10 currently but initial started it with Excel 2003- I know enough to be dangerous. I have a good size Excel application running. I'm using modified Dom Hill, June 2008 code to Create_PDFs. The code takes all of the sheets you want to print and combines them into one PDF...
  6. A

    How to print list of data into two columns on a page

    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...
  7. E

    Code to set print area - why wont this work?

    This code runs until this line "ActiveSheet.PageSetup.PrintArea = "A1:" & Last_Col & End_Row" and stops. What am I doing wrong? Sub Print_This_Analysis_Sheet() ' ' Print_Analysis_Sheet Macro ' ' Keyboard Shortcut: Ctrl+Shift+P ' Dim Last_Col As Integer Dim End_Row As Long 'Edit Print Area...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top