Error if no match found

[SMILE]

Hi..
Trying to find how to handle, if there is not a match found in monthsheet1 or monthsheet2.
appreciate help.

Please Login or Register  to view this content.

Thank you so much...

[Norie]

How have you declared row1 and row2?

[SMILE]

How have you declared row1 and row2?

dim row1 as long
dim row2 as long

[Norie]

Declare them as Variant, then you can test for error using IsError.

[SMILE]

Declare them as Variant, then you can test for error using IsError.

could you please write the code for IsError to handle the above example.
I would appreciate

[SMILE]

Can someone write me the ISERROR code to hand the above issue...
Will appreciate your help

[Norie]

What do you want to happen when there is an error?

[SMILE]

What do you want to happen when there is an error?

If there is no match in any of the sheets, then I need to go to the next x