2.) Describe "crash". What do you see; Does it lockup, does it exit excel?

3.) Remove the parenthesis
.Range("a1").PasteSpecial(Paste:=xlValues)