Alignment
Alignment Formatting: Command specifically related to formatting the alignment of the content inside the cell.
- Horizontal Alignment: Explains the different horizontal alignment formattings applicable to cells and range. Also provides the VBA code required to apply them.
- Excel VBA, Set Horizontal Alignment (Sample Code): An example on how to set the horizontal alignment of cells using VBA.
- Excel VBA, Get Horizontal Alignment (Sample Code): An example on how to get the horizontal alignment of cells using VBA.
- Vertical Alignment: Explains the different vertical alignment formattings applicable to cells and range. Also provides the VBA code required to apply them.
- Excel VBA, Set Vertical Alignment (Sample Code): An example on how to set the vertical alignment of cells using VBA.
- Excel VBA, Get Vertical Alignment (Sample Code): An example on how to get the vertical alignment of cells using VBA.
- Orientation: Explains how you can set the orientation of the content in cells and ranges. Also provides an example on how to get the current orientation of cells and ranges.
- Excel VBA Wrap Text On/Off: Explains how you can use VBA to modify the wrap text property of a cell or range. Also explains how you can use VBA to check the current status of the wrap text property for a cell or range.
- Excel VBA Shrink to Fit On/Off: Explains how you can use VBA to modify the shrink to fit property of a cell or range. Also explains how you can use VBA to check the current status of the shrink to fit property for a cell or range.
- Excel VBA, Merge Cells: Explains how to merge cells and ranges using VBA.
- Excel VBA, Reading Order: Provides the syntax required for changing the reading order of cells using VBA.
- Excel VBA, Get Cell Alignment Properties (Sample Code + Download): Provides a sample code for getting the alignment properties of cells using VBA.
- Excel VBA, Set Cell Alignment Properties (Sample Code + Download): Provides a sample code for setting the alignment properties of cells using VBA.