print area

  1. S

    Printing code ignores some data/pages

    Hello, I have this simple code Sub Printout() Sheets("Breakdowns").Select Range("A1", Range("A1").End(xlDown).End(xlToRight)).Select Selection.Printout And I am not sure why this code doesn't work properly. It somehow misses middle rows, but prints all other from start to end.
  2. B

    Force print area - does not change when hiding cells??? Help

    Hi All, I need some help with this one please. I have a spreadsheet that is a schedule, it lists week by week until the end of the year, this helps us plan out future works but we only send 2 weeks worth to a client. once the current week is over, we 'hide' the week, which in turn moves the new...
  3. M

    Pivot Table Print Area

    I have a pivot table that I have created a slicer for in order to select the data I want displayed. I created this pivot table as an attendance sheet for meetings. The pivot table grabs data from a spreadsheet containing all our employees. The person printing the attendance sheet would select...
  4. 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...
  5. C

    Macro needed for Formatting Print Area, Margins etc

    Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...
  6. J

    Printing after using "Page Break View"

    For some reason, when I try to change the number of columns that will appear when I print using "Page Break View" I'm now getting only every single cell highlighted -- a mass of squares -- and only half the page is shown when I hit print. This has happened in the past, and I don't remember how...
  7. M

    Dynamic Print Range (+ Inserting a text box)

    I'm trying to create a dynamic print range from A2, to F2, and extending to the last line with text. I've tried this code, and just can't seem to get it. Sub printFigure2() Dim ws2 As Worksheet Set ws2 = Worksheets("Figure 2-2") With ws2 .ResetAllPageBreaks With .PageSetup .PrintArea =...
  8. A

    Dynamic print area based on date

    Hello all, In my Excel I have a range of dates. This calendar consists of quite some cells. What I want is to automatically set the print area based on today's date including the range of two days before and two days after and always print the first column. For example if this is my sheet...
  9. E

    excel vba printpage are different values then on userform

    hi all when i print my userform listbox the values of 1 column change to a different value can someone tell me what i did wrong ? screenshot of what i want to print http://prntscr.com/keph0g code of printing Private Sub OUprint1() Me.Hide Dim rng As Range, wks As Worksheet, ListData() '...
  10. Toadstool

    Avoid Excel Print blank pages

    I'm looking for a function/formula or 1-off change solution to stop Excel printing blank pages. I have 100 rows of data and formulae, in case there is that many data entries to make, but most of the time there will be 10 or 12 data entries which should fit one page, the other rows returning...
  11. Johnny Thunder

    VBA Help - Setup where to insert Page break - Excel 2010

    Hi guys, Stuck on a code and can't seem to get it to work, hoping someone has come across this in the past or knows how to do this. I have a Set Print Area script that loops thru sheet in a newly added workbook and sets print area and some formatting and I added a line that inserts a page...
  12. B

    Retriving print zoom value

    I'm using Excel 2016 with Microsoft office 365. I need to retreive the pagesetup.zoom value for a area fitted into one page wide by one page tall. Some Introduction Before printing a worksheet, I want to run a page setup macro that will adjust the print zoom value to make sure the printed...
  13. U

    Publish as PDF - Blank sheets

    Writing a macro which publishes the content of a table as a .pdf, but the formatting goes off and most annoying the resulting pdf files include 100+ blank pages after the table... this really slows the whole job down; I've included the relevant code below...
  14. L

    Select Entire Sheet except print area

    Hi, I am looking for a macro or a solution to select the entire work sheet except the print area. Thanks, LenPL
  15. P

    mm grid, column width, row height

    1) Is there any excel 2013 template out there with which it is possible to print a millimeter grid on an A4-sheet of paper? 2) Is it possible in that grid from question 1 to match an (x,y) position on the excel screen with an (x,y) position on an A4-sheet of paper? 3) Can the column width and...
  16. S

    Printing a worksheet in Portrait and Landscape

    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
  17. J

    Set Page Break Cell Value Equals X with VBA

    Hello everyone, I am attempting to use the code below to insert a page break above every row where column C = "BOE Summary", But, the current code results in a Run Time Error 13: Type Mismatch. I would also like to set the print area from cell C2: "J" & End_Row (column J and the last row...
  18. zakasnak

    Print to single PDF Named Ranges on Multiple Sheets

    I have a workbook with 8 tabs containing named ranges that would like to print to a single PDF. The previous owner of this workbook used this macro, but we've gone through some system changes & it no longer works as an active printer on LPT1. Sub PDF_Print() ' ' PDF_Print Macro ' Macro...
  19. S

    VBA Print dynamic range

    Hi All I am struggling to find code for this, I have looked through the forums but haven't found one that works for me. All I want to do is have a print function on a report tab that varies in length depending on the results given. Columns will always be from $E2:$U - depending on the results...
  20. D

    Dynamic Print Area Excel 2016

    Evening All, Long time need more help please Im having some issues with Dynamic printing in excel. I would like to print a portion of my spreadsheet dependent on data entered the rows and columns are of set values and are as follows Namedrange1 (120 Rows 18 Col) Namedrange2 (184 Rows 18 Col)...

Some videos you may like

This Week's Hot Topics

Top