print area

So the short version is: I have a tool that makes signs for items. The paper it prints on is divided into 8 signs. (8.5x11 Sheet) I have tried every different option to get it to print properly and I cannot. Each page should have 8 signs. I keep getting overlap or width issues. ("A1:BM99")...

Hi All - I currently have a code that prints one of my worksheets to pdf just fine however, I've run into a new problem. I've now noticed that sometimes the data that needs to be printed overlaps the print areas and is either not captured or it prints in a mess across multiple pages breaking up...

I am trying to automate one of my spreasheets. I have an idea but because I have never used macros before, I don't know how to do it. I have a file (Excel 2010 at the moment) "sales statements generator". On one tab it has 500 statements to various customers, one under another, (formulas in...

I think I've found a bug in Excel, related to the print area. When I print to PDF on a VM that I don't have an open window to (using python to control Excel), the print area is ignored. Has anyone else experienced this, and has a workaround? Apologies for cross-posting to Stack Overflow, but...

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.

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

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

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

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

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

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

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

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() '...

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

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

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

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

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

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

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