Text Orientation

V

Vaibhav

Hi

I am trying to change the orientation of text displayed in a cell, but am
unable to do so. Can someone please adivse on the correct of setting cell
text orientation using OWC.

I know that there is a 'Orientation' property and have tried setting it
using the following method, but it does'nt work.

Dim xLO As OWC.XlOrientation

(''I have tried all the options mentioned below")

With xlSheet.ActiveSheet

Cells(2, 5).Value2.Orientation = -90

Cells(2, 5).Style = xLO.xlVertical

.Cells(2, 5).Value2.Orientation = xLO.xlVertical

.Range("E5").Orientation = OWC.XlOrientation.xlVertical

.Cells(2, 5).VerticalAlignment = OWC.XlOrientation.xlVertical

.Cells(2, 5).value2.Orientation = OWC.XlOrientation.xlVertical

Range("E5", "E5").Orientation = xLO.xlVertical

End With

Any help would be highly appreciated.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
range definition by cells numbers 3
Printing multi-page and multi-orientation excel tab to PDF 0
Multiple Page Report with Different Orientations 2
Sort all worksheets in a workbook 3
Horizontal orientation in table 10

Top