Hi all,

i am using error handler in VBA code. Let me first explain u the
situation.

i have to find out a no. from one work book in another work book.
though i have used Vlookup to do this but i wanna do this in other
way. i will copy that no from that work book and will search that in
other work book and will do this task for n no of times using loop.
till the time i find the no its fine but if the no. um searching is
not present in the other sheet macro will give an error (error -91)..
so to avoid this i used Error handler. like ..

for i = 1 to n
On Error goto err1:

code.........

...


err1:

next i

but the problem with this code is, the error handler will not work if
the same situation appears again..

so please help me ho shud i do this

This kind of code does not require an error handler. You are better off to
avoid the error in the first place. Post your code and we can take a look at
it.

To let you know what is going on once you encounter an error then your code
will be executing in error handling mode. You must clear that error using a
resume statement or a err.clear before you encounter another error otherwise
the new error will be unhandled (vba is still dealing with the first error).
--
HTH...

Jim Thomlinson


"sharad" wrote:

Hi all,

i am using error handler in VBA code. Let me first explain u the
situation.

i have to find out a no. from one work book in another work book.
though i have used Vlookup to do this but i wanna do this in other
way. i will copy that no from that work book and will search that in
other work book and will do this task for n no of times using loop.
till the time i find the no its fine but if the no. um searching is
not present in the other sheet macro will give an error (error -91)..
so to avoid this i used Error handler. like ..

for i = 1 to n
On Error goto err1:

code.........

...


err1:

next i

but the problem with this code is, the error handler will not work if
the same situation appears again..

so please help me ho shud i do this