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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't figure out this PasteSpecial error message 3
Pasting 2
Paste Special error in a Macro 3
Run Time Error 1004 7
Object variable or with Block variable not set 9
Paste Special - Values code 5
Help with this code please !!!!!!! 4
Variable not defined for "number of trials" ? 3

Back
Top