Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Software Development Software Development
Search Search
Search for:
Tech Support Guy > > >

Speed up printing in excel


(!)

bhurkie's Avatar
bhurkie bhurkie is offline
Computer Specs
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Jan 2012
Experience: Intermediate
23-Jan-2012, 11:35 PM #1
Speed up printing in excel
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
Rollin_Again's Avatar
Member with 4,689 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
24-Jan-2012, 09:16 AM #2
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
bhurkie's Avatar
bhurkie bhurkie is offline
Computer Specs
Junior Member with 4 posts.
THREAD STARTER
 
Join Date: Jan 2012
Experience: Intermediate
24-Jan-2012, 03:07 PM #3
I'm not exactly sure, but I think the code is running slow.

Thanks
Rollin_Again's Avatar
Member with 4,689 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
25-Jan-2012, 08:39 AM #4
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑