1 Reply Latest reply: Nov 23, 2015 4:48 AM by Marcus Sommer RSS

    VBScript xlHAlignLeft

    Neil Woodham

      My VBscript for columnwidth is working but the alignment is not.

      Any ideas why this would not work in an inline process??


      objCurrentSheet.Columns("A").ColumnWidth = 35
      objCurrentSheet.Columns("B").ColumnWidth = 125
      objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft

        • Re: VBScript xlHAlignLeft
          Marcus Sommer

          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:


          objCurrentSheet.Columns("A").HorizontalAlignment = xlHAlignLeft


          Helpful is the using of the excel-vba direct-window and there:


          ?VarType(xlHAlignLeft) // and then enter


          - Marcus