topic PasteSpecial method of Worksheet class failed in QlikView https://community.qlik.com/t5/QlikView/PasteSpecial-method-of-Worksheet-class-failed/m-p/461573#M172365 <HTML><HEAD></HEAD><BODY><P>I'm getting a Pastespecial method of worksheet class failed error and I'm not sure why since the macro had only just started to fail after working for the previous 6 months.</P><P></P><P>Here is what the code looks like where it is failing:</P><P></P><P>SUB Copysheet(xl,docsheet,chart)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set obj = ActiveDocument.Sheets(docsheet).SheetObjects(chart)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;obj.copytabletoclipboard true</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xl.ActiveSheet.PasteSpecial -4163,-4142,0,0</P><P>END SUB</P><P></P><P>Any ideas as to what the problem could be?</P></BODY></HTML> Wed, 20 Mar 2013 19:14:46 GMT Anonymous 2013-03-20T19:14:46Z PasteSpecial method of Worksheet class failed https://community.qlik.com/t5/QlikView/PasteSpecial-method-of-Worksheet-class-failed/m-p/461573#M172365 <HTML><HEAD></HEAD><BODY><P>I'm getting a Pastespecial method of worksheet class failed error and I'm not sure why since the macro had only just started to fail after working for the previous 6 months.</P><P></P><P>Here is what the code looks like where it is failing:</P><P></P><P>SUB Copysheet(xl,docsheet,chart)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set obj = ActiveDocument.Sheets(docsheet).SheetObjects(chart)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;obj.copytabletoclipboard true</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xl.ActiveSheet.PasteSpecial -4163,-4142,0,0</P><P>END SUB</P><P></P><P>Any ideas as to what the problem could be?</P></BODY></HTML> Wed, 20 Mar 2013 19:14:46 GMT https://community.qlik.com/t5/QlikView/PasteSpecial-method-of-Worksheet-class-failed/m-p/461573#M172365 Anonymous 2013-03-20T19:14:46Z