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

[drrazor]

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

Worksheets("A").Range("A1").Copy
Worksheets("B").Range("B1:D4").AutoFilter Field:=3, Criteria1:="something"
Worksheets("B").Range("B2:D10").SpecialCells(xlCellTypeVisible).PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply

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)

Dim ac as Range
Worksheets("A").Range("B2").Copy
Worksheets("B").Range("B3").PasteSpecial xlPasteValues
ac.Select

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