Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Limit an GoTo Function command

I am writing VB code in Excel to reformat a number of Excel spreadsheets.
There's a section of the code where I have inserted an "On error GoTo
Function" command to skip past a section of code if certain requirements are
not met. However, if my code errors at any other place than in that one
section, the code loops back to the error function.

Is it possible to limit the section of code that the On Error GoTo Function
so secondary errors don't llop back to the defined function?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,533
Default Limit an GoTo Function command

Hi

Use code below to disable your Error Handler :

On Error Goto 0

Regards,
Per

"lbsstacey" skrev i meddelelsen
...
I am writing VB code in Excel to reformat a number of Excel spreadsheets.
There's a section of the code where I have inserted an "On error GoTo
Function" command to skip past a section of code if certain requirements
are
not met. However, if my code errors at any other place than in that one
section, the code loops back to the error function.

Is it possible to limit the section of code that the On Error GoTo
Function
so secondary errors don't llop back to the defined function?


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
command code ( GOTO command) in formula calan New Users to Excel 1 June 11th 09 09:44 AM
Error with Goto command excelnut1954 Excel Programming 3 October 13th 06 02:48 PM
USING A GOTO COMMAND IN EXCEL gscar2005 Excel Worksheet Functions 1 February 9th 05 05:30 AM
Goto Command in Code JimPNicholls Excel Programming 2 September 1st 04 12:38 PM
search or goto command needed. mightymax Excel Programming 1 July 26th 04 03:42 AM


All times are GMT +1. The time now is 08:34 AM.

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"