Help with Error Handling

[vpnvipin]

Hi All,
*
Firstly let me thanks to the admin and all the members for
their wonderful job which they are contributing in this great forum. I have
learnt a lot from all of you.

Please see below specific points for what I have and what I need, apologies in advance if I this is not very clear

I want a function where user has to get a msg " You are taking an incorrect worksheet and lal al "" instead of scary error message

I tried to create on but not working out here is the code

Please Login or Register  to view this content.

[Sindhus]

You need to create a errorhandler label. Before your error msgbox, add ErrorHandler:

[vpnvipin]

Hi ,

Still its not pulling .. my actual error msg is Runtime error '9' subscript out of range

Please Login or Register  to view this content.

[vpnvipin]

I tried adding errhandler just before msgbox also .. not workign

[vpnvipin]

Sorry I got It now , its working .. I made a mistake at putting ' on 'On Error GoTo ErrorHandler

Thanks a lot Sindhu