page break setup

  1. S

    VBA Code to remove page breaks giving range error HELP

    I am unable to figure out how to write the VBA code to ignore page breaks if certain rows are hidden / allow page breaks if rows are not hidden. I am new to VBA code writing. I have checkboxes that when selected the rows will hide or expand when checked. I have the following print command...
  2. J

    Excel to Word page break

    Hi All, yesterday I've been helped beautifully and now I'm stuck again...:confused: My code now copies ranges from Excel to Word nicely, but I need to add page breaks. If I just run the code wdDoc.Range(wdDoc.Content.End - 1).InsertBreak Type:=7 it works, but when added to the existing code...
  3. K

    printing duplex with different sheets on page 1 & same sheet page 2

    Sorry if this question has been asked before. am using excel97. I have dozens of worksheets all different, I want to be able to print all these duplex The sheets have all previously been set up as 1 page containing only the ranges required. Odd pages should change but even pages should remain...
  4. SonGunnar

    Insert Page Breaks and Adjust Rows XL2003

    Problems: Groups of data should not split at inserted page breaks. Row heights vary at the 3rd and 5th row of each 7 row group. Typical pages have between 4 and 6 groups. Average projects contain 10 - 50 pages, or 40 - 250 groups. What I am trying to do is adjust the height of every 5th and 7th...
  5. W

    Automatically Resize Entire Workbook

    Hi Everyone, I have a 40+ page workbook that I'm working and I need to print every sheet in the workbook on legal size paper, and each sheet can not be > one legal piece of paper The macro will cycle thru all the sheets in the workbook, yet it will only adjust the current active sheet. I...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top