Runtime error 13 type mismatch when inserting columns

Hi
Im using a macro for two-way linking between two tabs. The linking works fine, but when I insert rows or columns in either of the linked tabs, or other tabs in the worksheet, I get a "Runtime error 13 type mismatch" error.

Any ideas where Im going wrong and can stop the error? Code below and sheet attached.
Note, the two linked cells are named Cell1 for the Sheet1 tab, Cell2 for Sheet2 tab.

Please Login or Register  to view this content.

Thanks in advance...Chris

Hi Debraj , thats reassuringly unhelpful ! : )
did you use the sheet I attached or just the code? Ive closed all excel and retried but still the error pops up.

brilliant, thats works perfectly !

Thank you so much.

Chris