topic Re: Insert Copied Cells Macro in QlikView https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112221#M367699 <HTML><HEAD></HEAD><BODY><P>Not quite what I wanted but thanks anyway.</P></BODY></HTML> Mon, 06 Jun 2016 09:05:53 GMT 2016-06-06T09:05:53Z Insert Copied Cells Macro https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112219#M367697 <HTML><HEAD></HEAD><BODY><P>Mods, please close.</P></BODY></HTML> Thu, 02 Jun 2016 09:18:08 GMT https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112219#M367697 2016-06-02T09:18:08Z Re: Insert Copied Cells Macro https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112220#M367698 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please <SPAN style="color: #ff0000;">delete&nbsp; "red color cells"</SPAN></P><P></P><P>and</P><P></P><P>after&nbsp;&nbsp; </P><P><SPAN style="color: #000000; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">objSheet.PasteSpecial(xlPasteValues)</SPAN></P><P></P><P><SPAN style="color: #99cc00;">&nbsp; </SPAN><SPAN style="color: #0000ff;">lrow = objSheet.Range("B10000").END(xlup).row&nbsp;&nbsp; 'for finding lastrow after the data copied</SPAN></P><P></P><P><SPAN style="color: #0000ff;">Range(Cells(lrow, 2), Cells(lrow + 1, 9)).Select&nbsp;&nbsp; 'selecting two last rows</SPAN></P><P></P><P><SPAN style="color: #0000ff;">Selection.Interior.color = vbred&nbsp;&nbsp;&nbsp; ' formatting as red cells </SPAN></P></BODY></HTML> Thu, 02 Jun 2016 13:29:40 GMT https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112220#M367698 Anonymous 2016-06-02T13:29:40Z Re: Insert Copied Cells Macro https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112221#M367699 <HTML><HEAD></HEAD><BODY><P>Not quite what I wanted but thanks anyway.</P></BODY></HTML> Mon, 06 Jun 2016 09:05:53 GMT https://community.qlik.com/t5/QlikView/Insert-Copied-Cells-Macro/m-p/1112221#M367699 2016-06-06T09:05:53Z