Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm having real trouble trapping this error. I have a sub where the active printer is changed Application.ActivePrinter = ListBox1.value if the printer is networked then it works fine, but if it isn't I get a run-time error 1004 Method 'ActivePrinter' of object'_Application' failed Is there any way I can user On Error GoTo Errorhandler to display the message "Printer Not Mapped" if this happpens? Thanks in advance Libby (xl97) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Trapping | Excel Discussion (Misc queries) | |||
Trapping #VALUE! error | Excel Discussion (Misc queries) | |||
Error Trapping from WSH | Excel Discussion (Misc queries) | |||
error trapping | Excel Discussion (Misc queries) | |||
Remind me to set Error Trapping to Break on Unhandled Errors | Excel Programming |