Switching from Excel 2010 to Excel 2013 lots, lots of errors

Hello,
I recently started to use Excel 2013, and I've got few problems with working on it. One of the most common is the issue that I can't copy from one sheet to another without selecting it. For example:

I'm running macro from sheet A

Please Login or Register  to view this content.

and now I want to do something on Sheet ("A") but I end up with "B" selected and active.

Second sample issue is setting Range variable (while sheet "A" is selected)

Please Login or Register  to view this content.

and on ac.Select it throws me back error, and likewise above macro ends up with sheet "B" active and selected.

It throws the error on the 2nd code because ActiveCell isnt a valid variable type, I removed the 2 ac lines and it worked fine.

So dont bother copying and pasting then, simply place the value in.

replace the 4 lines of the 2nd code with a single line of:

Please Login or Register  to view this content.