1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Speed up printing in excel

Discussion in 'Software Development' started by bhurkie, Jan 23, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. bhurkie

    bhurkie Thread Starter

    Joined:
    Jan 2, 2012
    Messages:
    4
    Hi Tech Guys,
    I need some help to speed up printing when using this macro. I am using a Brother QL 570 printer with 2'' non adhesive tape.

    Thanks.

    Range("H14").Select
    Selection.Copy
    ActiveWindow.ScrollWorkbookTabs Position:=xlLast
    Sheets("Race Variables").Select
    Range("B2").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Range("C2").Select
    Application.CutCopyMode = False
    Selection.Copy
    Application.CutCopyMode = False
    ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
    Sheets("Race 9").Select
    ActiveWindow.ScrollWorkbookTabs Position:=xlLast
    Sheets("Race Variables").Select
    Selection.Copy
    ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
    Sheets("Race 9").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False
    curPrtArea = ActiveSheet.PageSetup.PrintArea
    myPrtArea = "n42:n48"
    ActiveSheet.PageSetup.PrintArea = myPrtArea
    ActiveSheet.PrintOut
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    I'm confused by what you are asking for. Are you saying that the code above is running slowly or is the printer just slow when actually printing?

    Rollin
     
  3. bhurkie

    bhurkie Thread Starter

    Joined:
    Jan 2, 2012
    Messages:
    4
    I'm not exactly sure, but I think the code is running slow.

    Thanks
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    So when you manually format and print the workbook is the speed ok? Do any other applications have issues with printing? Add a messagebox to the very end of the code and when you fire the macro the messagebox should appear almost instaneously. If there is a delay in seeing the messagebox it means the code needs tweaking. If the messagebox appears quickly then it is likely a hardware or operating system issue that is causing the slowness.

    Rollin
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1037815