How to do Error handling for a sample Excel vba code?

[ravikumar00008]

Hi All,


Can anyone help me how to do error handling with a sample code?


Thanks in advance.


Regards

Kumar

 

[kaushik03]

Hi ravikumar00008,


The basic structure of a macro to handle errors is as follows:


Sub MyMacro()


On Error GoTo ErrorHandler

. . .

Exit Sub


ErrorHandler:

. . .

Resume <or Exit Sub>

. . .


End Sub


Following is an example for your reference:


http://www.vbaexpress.com/kb/getarticle.php?kb_id=189


Hope this helps.


In case you want a specific answer for your dataset which you might be working with, please consider uploading a file along with a short description of your key requirement.


Regards,

Kaushik