Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default on error resume next dilemna

I have been experiencing a problem recently that is sporadic but increasing.
Using VBA I have a line of code On Error Resume Next. I have been using
this command for years and never experienced this. The line is not
recognized when the program runs. If I go to the row above and hit enter to
shift the command down a line it works - sometimes.

Also, other programs will just run away and ingnore the lines of code. If I
shift the rows down a line to 2 it works. Sometimes I have to exit excel
and start again. I think this started after the last service pack update.

Help

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default on error resume next dilemna

Hello Greg,

Could you post the code that incorporates the On error. Bit difficult to
assess what might be occurring without it.

--
Regards,

OssieMac


"greg dixon" wrote:

I have been experiencing a problem recently that is sporadic but increasing.
Using VBA I have a line of code On Error Resume Next. I have been using
this command for years and never experienced this. The line is not
recognized when the program runs. If I go to the row above and hit enter to
shift the command down a line it works - sometimes.

Also, other programs will just run away and ingnore the lines of code. If I
shift the rows down a line to 2 it works. Sometimes I have to exit excel
and start again. I think this started after the last service pack update.

Help


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
On Error Resume Next Dan Excel Programming 5 August 19th 06 10:07 PM
On Error {...} Resume Next Edd[_2_] Excel Programming 2 March 15th 06 11:09 PM
On Error Resume Next ? Nigel Excel Programming 4 August 11th 05 09:07 AM
On Error Resume Next Mike Archer[_2_] Excel Programming 3 March 2nd 05 01:41 PM
On Error Resume Next D.S.[_3_] Excel Programming 1 November 28th 03 04:52 PM


All times are GMT +1. The time now is 11:47 PM.

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

About Us

"It's about Microsoft Excel"