Selecting an entire column and aligning it upon worksheet change.

[emilyloz]

Hello,

I'm using matlab to export data into an excel sheet, I'm having trouble with the matlab syntax so i thought itd be easier to write a sub for worksheet change.

Matlab will be exporting to the same workbook every time.

Upon changes occurring on the workbook, I want to select the B column, and align the contents in it to the right.
Please help

the sheet is Sheet1

Thanks!

[protonLeah]

Please Login or Register  to view this content.

[emilyloz]

Please Login or Register  to view this content.

Thanks.

will this be under:

Private sub Worksheet_change()

end sub?

and also,

do i just type xlright if i want it aligned right?

[protonLeah]

I'm not sure what you are doing, but

Please Login or Register  to view this content.

will work. But the code will run each and every time a change is made in the sheet.
You can choose xlRight, xlCenter or xlLeft in the simplest cases.