cell text alignment vertical - using VBA

Originally Posted by Dabooj

Hi guys,

I have column headings (text) in cells across my spreadsheet. I have a button which formats these headings (colour, font, size & Background colour, etc) using VBA code for automation purposes.
What i would like to do is also have these headings displayed vertically instead of the default horizontal view. I know you can do this by going into the cell properties but i was wondering whether it was possible to do this thru VBA code?
Is there a VBA command or setting that will change the Text to vertical?

Regards,

Shuja

Please Login or Register  to view this content.

Adjust for your range as appropriate.

Rgds

Thanks, that works fine.

Shuja