View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default On error resume next problem

Next time you're in the VBE, try:

Tools|Options|General tab
check "Break on Unhandled Errors"

I'm betting that you have "break on all errors" checked.

freekrill wrote:

I have some code which looks something like this

On error Resume Next
Kill "C:\a.xls"
Kill "C:\b.xls"
Kill "C:\c.xls"
Kill "C:\d.xls"
Kill "C:\e.xls"
On error goto 0

It works ok, but if the file doesn't exist the macro breaks and I get
an error message. Shouldn't the instruction, On error Resume Next,
prevent this problem?

Thanks for any explanation

Cheers
free

--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=490966


--

Dave Peterson