View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default VBA Code Works in 97, Not in 2002

Glad you got it working.

I feel a lot better when I use "on error resume next" sparingly. And then turn
it off right after the code that causes error I expect to sometimes occur is
finished. Same with .displayalerts.

And just because the code runs to completion, it doesn't mean that it did what I
wanted. Those resume next lines mask too much to be left on.

EC wrote:

William & Dave,

Sorry for taking so long to respond to your prior posts. Here's what
has happened since I last posted.

As recommended, I commented all "On Error Resume Next" statements and
stepped through the code. In the "problematic" section (the earlier
posted "snippet"), I found two errors:


--

Dave Peterson