topic Macro to put a border in excel sheet in QlikView https://community.qlik.com/t5/QlikView/Macro-to-put-a-border-in-excel-sheet/m-p/159864#M34345 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am writing a macro to export some object's in my chart to excel. I want to put border around the chart , I am writing a code like this</P><P></P><P>LastRow = MyTable.GetRowCount</P><P>XLSheet.Range("A1:A" &amp; LastRow).BorderAround Weight=1</P><P>but it's not working. Anyone do have any idea how to put the border in an excel macro. If anyone could tell me that. Thank's in advance.</P><P>Regard's</P><P>Amar</P><P></P><P></P><P></P><DIV></DIV><P></P></BODY></HTML> Tue, 18 Aug 2009 19:04:18 GMT amars 2009-08-18T19:04:18Z Macro to put a border in excel sheet https://community.qlik.com/t5/QlikView/Macro-to-put-a-border-in-excel-sheet/m-p/159864#M34345 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am writing a macro to export some object's in my chart to excel. I want to put border around the chart , I am writing a code like this</P><P></P><P>LastRow = MyTable.GetRowCount</P><P>XLSheet.Range("A1:A" &amp; LastRow).BorderAround Weight=1</P><P>but it's not working. Anyone do have any idea how to put the border in an excel macro. If anyone could tell me that. Thank's in advance.</P><P>Regard's</P><P>Amar</P><P></P><P></P><P></P><DIV></DIV><P></P></BODY></HTML> Tue, 18 Aug 2009 19:04:18 GMT https://community.qlik.com/t5/QlikView/Macro-to-put-a-border-in-excel-sheet/m-p/159864#M34345 amars 2009-08-18T19:04:18Z