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