Aren't you missing some parameters ?see the link below - beware of wordwrapwww.google.com/search,GGLG:2005-38,G\GLG:en&q=excel+vba+%22PasteSpecial+Method%22