how to make code work

Hi,

I have two codes that workes seperatly, but cant make them work together.
Regarding to macrocoding i´m in the startpitch, so it would be fantastic if somebody could have a look at this and maybe help me make it work.

Hopefully also explane the different parts of the code for me.

I have attached a printscreen of the code with the error i get.

Regards
Oeysbrei