>i tried your solution but somehow it doesn't work.
>
>i want to leftalign my column .
>
>regards,
>David van der vliet

Hello David,

You have to set IndentLevel property also.

Here is the sample code:

PUBLIC ox
ox = CREATEOBJECT('excel.application')
ox.WorkBooks.ADD()
ox.VISIBLE = .T.

ox.ActiveWorkbook.Worksheets(1).Activate()

WITH ox.ActiveWorkbook.ActiveSheet 
.cells(1,1) = 123
.cells(2,1) = 456
.cells(3,1) = 789
ENDWITH

ox.ActiveWorkbook.ActiveSheet.Columns('A:A').Select()
WITH ox.Selection
        .HorizontalAlignment = -4152 &&  xlLeft
       .IndentLevel = 0
ENDWITH

Nick