Aligning using Excel Buffer

Archy
Archy Member Posts: 70
Hi all!

Does anyone knows, how to align center cell in excel file? I'm using an excel buffer now.

Thanks for help!

Comments

  • Navsyst2
    Navsyst2 Member Posts: 29
    The Command ist HorizontalAlignment.

    XlWrkSht.Range(xlColID + xlRowID).HorizontalAlignment := HorzAlign;

    //Option value for HorizontalAlignment :
    2=Left
    3=Center
    4=Right