Excel center column and row

[dickep]

I know this has been asked and answered, but my search did not find anything.

So, I have an excel spreadsheet that I put data into using Autoit. However, I have changed the row height OK, but just cannot figure out how to center the data in the cell both vertically and horizontally.

Any help would be appreciated.

Thanks

E

[water]

Use the HorizontalAlignment and VerticalAlignment properties:

$oExcel.Activesheet.Columns("A:F" ).HorizontalAlignment = 7

or use function _ExcelHorizontalAlignSet found in the Excel UDF.

The constants used by Excel can be found here.

[dickep]

water, thank you. However the 7 was incorrect, should have been -4108 (or use $xlCenter variable out of Excel.au3).

You pointed me into the right direction.

Now to move to the next challenge.

E