Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2008

Tip: Looking for answers? Try searching our database.

Limit an GoTo Function command

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lbsstacey - 18 Apr 2008 13:21 GMT
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?
Per Jessen - 18 Apr 2008 13:44 GMT
Hi

Use code below to disable your Error Handler :

On Error Goto 0

Regards,
Per

>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
[quoted text clipped - 6 lines]
> Function
> so secondary errors don't llop back to the defined function?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.