![]() ![]() The value of this property can be set to an integer value from –90 to 90 degrees or to one of the following constants: xlDownward, xlHorizontal, xlUpward, xlVertical. Range("A1").ReadingOrder = xlRTL Orientation The following code example sets the reading order of cell A1 to xlRTL (right-to-left). The value of this property can be set to one of the constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext (context). Range("A1:A4").MergeCells = True Right-to-left Text direction This example merge range A1:A4 to a large one. This example causes text in row one to automatically shrink to fit in the available column width. Range("A1").WrapText = True Shrink To Fit This example formats cell A1 so that the text wraps within the cell. ![]() Range("A1").VerticalAlignment = xlBottom Text Control Wrap Text ![]() The following code sets the vertical alignment of cell A1 to bottom. The value of this property can be set to one of the constants: xlBottom, xlCenter, xlDistributed, xlJustify, xlTop. Range("A1").HorizontalAlignment = xlCenter Vertical ![]() The following code sets the horizontal alignment of cell A1 to center. The value of this property can be set to one of the constants: xlGeneral, xlCenter, xlDistributed, xlJustify, xlLeft, xlRight. Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,#0.00" Accounting Range("A1").NumberFormat = "_($* #,#0.00_) _($* (#,#0.00) _($* Date Range("A1").NumberFormat = Time Range("A1").NumberFormat = "h:mm:ss Percentage Range("A1").NumberFormat = "0.00%" Fraction Range("A1").NumberFormat = "# ?/?" Scientific Range("A1").NumberFormat = "0.00E+00" Text Range("A1").NumberFormat = Special Range("A1").NumberFormat = "00000" Custom Range("A1").NumberFormat = "$#,#0.00_) ($#,#0.00)" Formatting Cells Alignment Text Alignment Horizontal ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |