Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default turn off error handling

Hello,

I've got an error in my workbook, but it doesn't effect the
functionality. Is it possible to turn of the error message/prompt? (So
that in the meanwhile I can solve the bug)

bernd

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default turn off error handling

On Error Resume Next

Place it before the error may occur

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"bernd" wrote:

Hello,

I've got an error in my workbook, but it doesn't effect the
functionality. Is it possible to turn of the error message/prompt? (So
that in the meanwhile I can solve the bug)

bernd


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default turn off error handling

On Error Resume Next
'that code
On Error Goto 0

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bernd" wrote in message
ups.com...
Hello,

I've got an error in my workbook, but it doesn't effect the
functionality. Is it possible to turn of the error message/prompt? (So
that in the meanwhile I can solve the bug)

bernd



Reply
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 Handling rsphorler Excel Programming 5 May 20th 07 02:06 AM
Error Handling - On Error GoTo doesn't trap error successfully David Excel Programming 9 February 16th 06 05:59 PM
error handling Pierre via OfficeKB.com[_2_] Excel Programming 0 November 2nd 05 09:19 AM
Error handling with a handling routine ben Excel Programming 0 March 15th 05 03:01 PM
Error Handling Rob Bovey Excel Programming 0 August 7th 03 12:11 AM


All times are GMT +1. The time now is 02:54 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"