topic VBScript xlHAlignLeft in QlikView https://community.qlik.com/t5/QlikView/VBScript-xlHAlignLeft/m-p/961313#M644476 <HTML><HEAD></HEAD><BODY><P><BR />My VBscript for columnwidth is working but the alignment is not.</P><P>Any ideas why this would not work in an inline process??</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>objCurrentSheet.Columns("A").ColumnWidth = 35<BR />objCurrentSheet.Columns("B").ColumnWidth = 125 <BR />objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft </P></BODY></HTML> Mon, 23 Nov 2015 08:55:04 GMT tinkerz1 2015-11-23T08:55:04Z VBScript xlHAlignLeft https://community.qlik.com/t5/QlikView/VBScript-xlHAlignLeft/m-p/961313#M644476 <HTML><HEAD></HEAD><BODY><P><BR />My VBscript for columnwidth is working but the alignment is not.</P><P>Any ideas why this would not work in an inline process??</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>objCurrentSheet.Columns("A").ColumnWidth = 35<BR />objCurrentSheet.Columns("B").ColumnWidth = 125 <BR />objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft </P></BODY></HTML> Mon, 23 Nov 2015 08:55:04 GMT https://community.qlik.com/t5/QlikView/VBScript-xlHAlignLeft/m-p/961313#M644476 tinkerz1 2015-11-23T08:55:04Z Re: VBScript xlHAlignLeft https://community.qlik.com/t5/QlikView/VBScript-xlHAlignLeft/m-p/961314#M644477 <HTML><HEAD></HEAD><BODY><P>The xl-constants won't be regocnized in each case. You could try it only with xlLeft but mostly are the numeric equivalent from these xl-constants better to use. In your case try it with 3:</P><P></P><P>objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft</P><P></P><P>Helpful is the using of the excel-vba direct-window and there:</P><P></P><P>?VarType(xlHAlignLeft) // and then enter</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 23 Nov 2015 09:48:26 GMT https://community.qlik.com/t5/QlikView/VBScript-xlHAlignLeft/m-p/961314#M644477 marcus_sommer 2015-11-23T09:48:26Z