Tag Archives: alignment

No Thumbnail

Excel VBA, Merge Cells

In this article I will explain how you can use VBA to merge cells in Excel. I have also provided two sample codes. Jump To: Basics, MergeCells Example 1, Merge Rows Example 2, Merge Columns You can download the code and file related to this

No Thumbnail

Excel VBA, Set Vertical Alignment (Sample Code)

In this article I will provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical  alignment will be applied to the cell below the drop down list. You can download the file and code related to this article here. Upon

No Thumbnail

Excel VBA, Horizontal Alignment

In this article I will explain the different horizontal alignment formattings applicable to cells and range. I have also provided the VBA code required to apply them. For examples using horizontal alignment in VBA code please see: Excel VBA, Set Horizontal Alignment, (Sample Code) Excel

No Thumbnail

Excel VBA, Get Horizontal Alignment (Sample Code)

In this article I will provide an example on how to find cells with a specific horizontal alignment. You can download the code and file related to this article here. The user selects the desired horizontal alignment to find from a drop down list: After pressing

No Thumbnail

Excel VBA, Wrap Text On/Off

In this article I will explain how you can use VBA to modify the wrap text property of a cell or range. I will also explain how you can use VBA to check the current status of the wrap text property for a cell or

No Thumbnail

VBA Excel, Alignment

The following article explains the different alignment formattings applicable to cells and ranges and provides reference for more detailed explanation. When right click on a cell and select Format Cells … a dialog will open: The dialog has an alignment tab: The alignment tab displays all the

No Thumbnail

Excel VBA, Shrink To Fit On/Off

In this article I will explain how you can use VBA to modify the shrink to fit property of a cell or range. I will also explain how you can use VBA to check the current status of the shrink to fit property of a cell or

No Thumbnail

Excel VBA, Reading Order

Left to Right, xlLTR: The following line of code applies the left to right reading order format to cell A1: Range(“A1”).ReadingOrder = xlLTR – Right to Left, xlRTL: The following line of code applies the right to left reading order format to cell A1: Range(“A1”).ReadingOrder