Frequently when I write code such as the following...
Sheets("Sheet2").Range("A2").Paste
I get runtime error 438 "object doesn't support this property or method"
I usually just change it to .PasteSpecial or try another way of pasting and work it out. However, I have never understood why...