VBA range class failed

Asked Jan 17 '20 at 12:47

Active Jan 17 '20 at 12:57

Viewed 37 times

I am trying to copy from one workbook to a specific worksheet in another workbook but I keep getting Run-time error '1004': PasteSpecial method of range class failed. This is my code below. The error is here ( Selection.PasteSpecial Paste:=xlPasteValues). Can someone help me please

Range("A1").Select
Workbooks.Open Filename:= _
    "K:\HSC LTD 2019-2020\Tools\Sales _ HSC LRM Invoice template\HSCLRM 2020\Fee Report 130120 to 160120.xlsm"
Range("M3:P63").Select
Selection.Copy
   ActiveWindow.Close
    Worksheets("Paste Data").Activate

Range("A1").Activate

Range("A1").Select
 Selection.PasteSpecial Paste:=xlPasteValues

End Sub

edited Jan 17 '20 at 12:57

JvdV

70,606
8
39
70

asked Jan 17 '20 at 12:47

Mond

2

[This](https://stackoverflow.com/a/10717999/9758194) post will probably get you there =) – JvdV Jan 17 '20 at 12:57
I'm guessing that closing the window clears the clipboard. – BigBen Jan 17 '20 at 13:38
Maybe. Should I don't close the window ? – Mond Jan 17 '20 at 14:48

VBA range class failed

0 Answers0