Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Set PageSetup = Nothing????

  1. #1
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    864
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've got a complex VBA application. The thing runs really fast. Until I print the worksheet.

    After printing the worksheet, the pagebreaks lines appear and the code runs at least 10 times slower than without the pagebreak lines.

    The *right* thing to do is to figure out why this is happening, but the *quick* thing I am trying to do (spring break starts in 3 days) is to find a way to basically set the PageSetup to nothing. Friends who have an international version of Excel suggested

    Set ActiveSheet.PageSetup = Nothing

    but this causes an object 438 error for me in Excel 2000 or Excel 2002.

    Any idea on how to "undo" the page setup settings so that this application can go back to it's speedy performance after printing?

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Bill

    Try:

    ActiveSheet.DisplayAutomaticPageBreaks = False

    To get rid of those horrible page breaks.


    Where should I post the invoice? )







  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think this should also work :-

    Cells.PageBreak = xlNone

  4. #4
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know VB, but what about
    ActiveSheet.ResetAllPageBreaks
    Richard

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •