VBScript xlHAlignLeft

[tinkerz1]

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

[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