Dynamic check of cell content

Dear all

I'm stuck with quite some difficult problem:

I'd like to look for datas in a worksheet and transfer them to another one.

My problem: First, I had a static solution of my problem (code 1). This worked well. But now, static reference is no longer good for my task. I absolutely need a dynamic check of this cell. My attempt for a solution you can find in code 2.

Where's my mistake? Is there anyone who could help me, please?

Thank you very much for your help.

Best regards
Sparhawk

Code 1 (static) => works

Please Login or Register  to view this content.

Code 2 (dynamic) => doesn't work

Please Login or Register  to view this content.

Hi AlphaFrog

Thank you very much for your help. I tried it and it worked perfectly. This was really a precious hint, that ActiveCell only applies to the Active sheet.