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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top