with pastespecial you have to provide the correct arguments for the desired result

lookup in the help for powerpoint (not excel) to find what arguments are available for its pastespecial method, or look here
http://office.microsoft.com/en-us/po...010117115.aspx