Page 1 of 1

Alignement in Excel (solved)

Posted: Sun Oct 27, 2019 3:23 pm
by driessen
Hello,

I want to make an Excel-document from my FWH-application.

I need to align the cells in my Excel document.

To achieve tha, I try this :

Code: Select all

/* Explanation cPos :
   cPos = 0 -> Standaad alignement
   cPos = 1 -> Left alignement
   cPos = 2 -> Centered
   cPos = 3 -> Right alignement
   cPos = 4 -> Left + right alignement
*/
oSheet:Range("A1"):HorizontalAlignment := cPos
Unfortunately, nothing is changing.

What do I do wrong?
Does anyone have another suggestion?

Thanks a lot in advance for any help.

Re: Alignement in Excel

Posted: Sun Oct 27, 2019 3:28 pm
by cnavarro

Re: Alignement in Excel (solved)

Posted: Sun Oct 27, 2019 4:22 pm
by driessen
Thanks a lot for your help. It works just fine.

Sorry I couldn't remember my previous topic about this subject.