Clipboard to a defined sheet

[David2]

I have a very basic question.


I've pasting clipboard content to a certain sheet (Sheet5) in cell A1 (document contains more sheets).

Sub Copy()
ActiveSheet.Paste Destination:=Worksheets("Sheet5").Range("A1")
End Sub

I'm been getting a lot of 1004 errors (paste method of worksheet class failed).


How can I paste clipboard content to a certain sheet and avoid this error? I want to open the document and paste the clipboard content without having to click on Sheet5.

 

[My Aswer Is This]

Try this:
Worksheets("Sheet5").Range("A1").PasteSpecial

 

[David2]

Hm, now I get a new error - "PasteSpecial method of Range class failed."

Is this perhaps related to clipboard data?

 

[My Aswer Is This]

What do you have in the Clipboard?
I assumed it was plain Text.

 

[My Aswer Is This]

If you really think you need to use Paste Destination

Use this:

Paste Destination:=Worksheets("Sheet5").Range("A1")

But you do need to have a sheet named "Sheet5"

 

[David2]

My Aswer Is This,


yes it is plain text. Could it be related to an empty clipboard error?


Are there some other options than using Paste Destination? I mean, I have to paste clipboard data in a certain sheet and cell but how I do it, is irrelevant - I just want to get rid of that error or understand why it happens.

And thanks

 

[My Aswer Is This]

Try this:

Sub Copy_Me()
'Modified  12/8/2018  10:49:09 AM  EST
On Error GoTo M
Worksheets("Sheet5").Range("A1").PasteSpecial
Application.CutCopyMode = False
Exit Sub
M:
MsgBox "Your ClipBoard is empty"
End Sub

 

[David2]

This works perfectly! Thank you man.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

This works perfectly! Thank you man.