Hi & thanks for your reply! Please find attached the file. The workbook has two sheets. As you will note, there is a difference in cell B6 (the age is missing in the second sheet). When you now perform the macro, the code will drop you this difference. However, as soon as the sheets are equal (e.g. add 96 in the second sheet), I have the "out of range".
Bookmarks