What is wrong with this line of code
 

This was working fine before and all of a sudden I starting getting
"PasteSpecial method of Range class failed"

Selection.PasteSpecial Paste:=xlPasteAll

Any ideas why?

What is wrong with this line of code
 

Probably your Selection. PasteSpecial must have enough space to accommodate
what was put on the clipboard. Since you did not post all of the code, it
is just a guess.


"Ayo" wrote in message
...
This was working fine before and all of a sudden I starting getting
"PasteSpecial method of Range class failed"

Selection.PasteSpecial Paste:=xlPasteAll

Any ideas why?