Not running macro on automatic calculation

Right, this is now more wrong than i originallly thought,

1st. It is emailing everytime i select a new cell
2nd. It isnt picking up the next C column value
3rd. I have to click in column H or another cell before the code is run

I have attached the sheet, if you wouldnt mind taking a look for me???

I would really appreciate any help please

Thanks

I have left the design mode on so it doesnt keep emialing me every time a cell is clicked on

Dan