View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
renegan[_9_] renegan[_9_] is offline
external usenet poster
 
Posts: 1
Default PasteSpecial Method of Range Class Failed Error


Use

Application.CutCopyMode = False

only after you paste it. In your code it is used before you paste i
which will stop the copy-paste process. So your code cannot fin
anything to paste

--
renega
-----------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...fo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=52816