Need to understand error handling

kelly mort

Well-known Member
Joined
Apr 10, 2017
Messages
2,169
Office Version
  1. 2016
Platform
  1. Windows
Hello All,
I have been using some of the error handlers in my scripts. Well, i am an online learner and have learned most of these stuffs from videos where i did not get the opportunity to ask some questions. So i need help with the understanding of these error handlers. For example "on error goto 0", "on error resume next" etc. What do they actually do? Thanks.
Kelly
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
I have been using some of the error handlers in my scripts.

kelly mort,

See if the following will help you:

Go into the VBA Editor.

In the upper right hand box you will see "Type a question for help" without the " characters.

In the box, type in Error, and, press the Enter key.

A list will appear to assist you.
 
Upvote 0
kelly mort,

See if the following will help you:

Go into the VBA Editor.

In the upper right hand box you will see "Type a question for help" without the " characters.

In the box, type in Error, and, press the Enter key.

A list will appear to assist you.

Okay. I will give it a try. Will update you when i am through. Thanks
 
Upvote 0
Okay. Thanks but the link is not opening

Did you click the "I understand the risk. Proceed anyway." button? Since the link is not to the forum you get a warning before it is opened.
 
Upvote 0
I am on phone at the moment and my network seems to be slow a bit
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top