Problem with my If...Then...Else statement???

Hi,
I'm quite a beginner in macro generating and I have an issue, that I can't solve.. I have 3 separate Excel files (Table1...3). I have the macro in the 1st one.
The task is the following:
With the Do...Loop statement I want to go through on the 10 items in table1. Grabbing each item I want to find the same item in table2. If it can be found I want to copy and paste that and it's neighbour cells to table1, then I want to find the same item in table3 as well and copy from there a cell as well to table1. The problem occurs when the item can't be found in table2. That time I just want to move ahead to the next item to be searched, but the script always stops.
Where did I make a mistake??
table2.xlsxtable3.xlsxtable1.xlsm

Welcome to the Forum nagy.den!

There is no code in file table1.xlsm.

Sorry, meanwhile I found out the bug Thanks anyway

Please share the solution.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.