page break

  1. A

    VBA Print Page Breaks

    I have a sheet that shows account summaries for clients that are 5-10 rows long. When I print out the summary, I cannot use the "fit to x pages tall" method because I cant guarantee that it will not split in the middle of an account summary. I want to find the last full account summary that...
  2. 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...
  3. K

    Page Break Issue When Inserting Row

    I have two documents that are very similar. I am working from "Page Break Preview" view so that I can see where the page breaks are. In one document, when I insert a row above Row 1, the page break shifts down so that the new Row 1 (which was inserted) would not be printed. It is greyed out...
  4. N

    Excel - Pivot table - Print multiple files

    My Excel file has: Pivot table that sums sales territories with customer details. Pivot table has page breaks at every change in territory. When printing pivot table, each territory may contain 1-5 pages, depending on how many rows of customer details. eg, Territory 1 = (5) pgs, Territory 2 =...
  5. H

    Page Break or Print Issue - Probably Super Easy ... Need Your Help

    This issue is driving me insane, but hopefully an super easy fix ... I'm using Excel for Mac 2008. Each page has only one column (and 26 rows). My goal is to change this to a more normal setting where each page has multiple columns, but I can't figure out how. Does anyone know how to do this in...
  6. B

    Make page breaks land only on rows with bottom border

    Ihave a long report consisting of multi-line chunks of data separated byborders, and I have to print a new updated report every few weeks. Forreadability reasons, when it prints, the chunks of data cannot be split betweentwo pages, so if Excel puts a page break in the middle of a chunk, it has...
  7. 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...
  8. J

    Cannot click macro button while in page break preview?

    Hello, I am trying to use a macro button that allows the user to set the page breaks. The goal would be to have the button work as listed below... If ActiveSheet is in PageBreakPreview mode, then switch back to normal mode If ActiveSheet is in Normal mode, then switch to PageBreakPreview As...
  9. J

    Inserting PageBreak via a cell or group of cell constraints.

    Hello Excel world. So I have a very big list of (for this example lets call them) locations. See example: <colgroup><col></colgroup><tbody> 01 02 A 01 05 A 01 05 B 01 06 A 01 06 B PAGE BREAK 02 01A 02 01B 02 05A 02 05B 02 06A 02 06B PAGE BREAK 03 01 A 03 01 B...
  10. T

    vba to insert a page break at every occurence of the word "New Record" in column 1

    I need to loop through column one and insert a page break before every occurrence of the string "New Record" as the cell.value.
  11. R

    Inserting Page Breaks with Macro

    Hi and thank you for looking, I'm trying to create a macro to insert page breaks above each Header row (Row 1,7,11 in this ex) and if the data between each header contains more than 3 rows, insert a page break every 3 rows. So, below the macro would place a page break between row 4&5, 6&7...
  12. A

    Margins not saved for other users

    I have a workbook that I made for the office, which multiple people use. On my computer, the page breaks are set so each worksheet only prints on one page. However, when another user tries to print it comes out on 2-3 pages. I noticed that my margins were set as custom and their margins are...
  13. Roderick_E

    Automatic Pagebreaks

    On Excel 2007-2013, if I simply format a new sheet as landscape, narrow margins; there are automatic pagebreaks. They appear to be every 34 rows or positionally the first break appears at 513.75. You'd think you could just increase in increments of 513.75 to the next break but I'm doing...
  14. tycasey17

    Custom Headers at Page Breaks

    <tbody> Name ID # Job 1 State Status </tbody> Is there a way to have the above be at the top of all the pages without having to manually go into the page break or is there not a way to do it and I just need to get over it and manually adjust it.
  15. M

    page breaks with scale to fit or VBA to copy worksheets

    Hello, I have been searching the web forever to find a solution to my problem but have failed :( I'm not very knowledgeable of VBA so I can't write anything on my own. My issue is that I have multiple reports in 1 worksheet. Each report is separated with a page break but some of these reports...
  16. D

    Page Break Double Sided Printing

    Hi, I have a worksheet that I have inserted page breaks for to separate accounts (using subtotal). I now need to print it double sided, but if a group from one account ends on an odd page, the next group will start on backside. I need to file all accounts individually, so I need blank pages to...
  17. M

    Excel Page Break issues

    We have a spreadsheet in my workplace which is set up to print one page wide by one page high. When I make changes to this sheet on my PC, the system automkatically inserts a new page break on every row. If I use the page break preview and change the scale to 40% the page breaks get less and...
  18. S

    VBA: Page breaking new PDF

    Hello everyone. I'm developing a spreadsheet with some VBA codes. And one important part of it is the "SaveAsPDF" routine. However, in one of my sheets, there are 22 tables of varying height. Then, I'd like to know how can I insert page breaks after each table in the generated PDF, using the VBA...
  19. S

    Splitting data into several worksheets based on page breaks - help with VBA macro

    Hello, I am a novice when it comes to VBA - I can usually modify code that I find in forums such as these to get it to work for my circumstances, but I'm not great at creating my own. I'm hoping that someone can help me with a macro to split some data into separate worksheets based on page...
  20. D

    Macro to set page breaks with certain criteria

    I have a quote template that has about 8 sections to it, each section I have given a named range of Range1, Range2 and so on. I need a macro that will do the following: - Reset Page Breaks - Add page breaks as normal but do not split a Range up (so put the break at the beginning of the range...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top