LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Error Trap

I'm fairly new at programming - I've successfully written this code, but I'd
like to set an Error Trap in the event the ActivePrinter cannot be found.
Can someone provide the code I would need to accomplish this? Thank you!

Sheets(Array("Cover", "Consol PL", "AMER PL", "EMEA PL", "INDO PL", "ASIA
PL", _
"ACTIVE PL", "gcs pl", "wrls pl", "wline pl", "aps pl", "hmwx pl", "other
adc pl", _
"Consol BS", "Amer BS", "EMEA BS", "Indo-pac BS", "Asia BS", "Other
BS")).Select
Application.ActivePrinter = "Acrobat Distiller on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Acrobat Distiller on Ne01:", Collate:=True
Sheets("Input").Select



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Trap TEB2 Excel Programming 2 March 15th 05 05:34 PM
Error Trap Not Working Otto Moehrbach[_6_] Excel Programming 7 April 13th 04 12:15 PM
Trap a DateValue Error Otto Moehrbach[_6_] Excel Programming 2 February 12th 04 04:51 PM
error trap Rhonda[_3_] Excel Programming 2 October 22nd 03 07:07 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"