What is wrong with this line of code

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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?
 
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.
 
Back
Top