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