VBA Merge Cells

Associated Files Download Links

In this tutorial, we are going to look at the different ways you can merge cells using VBA.

Merge Cells Using VBA

You can merge cells in VBA using the Range.Merge method. The following code will merge cells A1:C1:

The result is:

How to Merge Cells in VBA

Unmerge Cells Using VBA

You can unmerge a merged cell range using the Range.UnMerge method. Let’s say you’ve merged the cell range A1:D1. You can use one of the cell references in the range to unmerge the cells. The following code shows you how to unmerge cells A1:D1, in this case we are using cell B1:

Merge Rows Using VBA

You can merge rows using VBA by specifying the row numbers that you want to merge. We have the text in cell A1 shown below:

Merging Rows Using VBA

The following code will merge rows 1-4:

The result is:

Merging Rows Using VBA

Merge Columns Using VBA

You can merge columns using VBA and the column letters. The following code will merge columns A:C.

The result is:

Merging Columns In VBA

Merge and Center Cell Contents Horizontally

You can merge and center cell contents horizontally across a cell range. You have to merge the cells of interest and also set the horizontal alignment property of the range object to center. We have the text in cell A1 as shown below:

Merge Cells Horizontally Using VBA

The following code will merge the cell range A1:D1 and center the contents of cell A1 horizontally across this cell range:

The result is:

Merging and Centering Cells Contents in VBA Horizontally

Merge and Center Cell Contents Vertically

You can merge and center cell contents vertically across a cell range. You have to merge the cells of interest and also set the vertical alignment property of the range object to center. We have the text in cell A1 as shown below:

Merging Cells in VBA using Vertical Alignment

The following code will merge the cell range A1:A4 and center the contents of cell A1 vertically across this cell range:

The result is:

Merging Cells Using Vertical Alignment in VBA

Merge Cells Across a Cell Range

You can merge cells across a cell range. You have to set the optional Across parameter of the Merge method to True. We have the text in cell A1 as shown below:

Merge Cells Across in VBA

The following code will merge the cell range A1:D1:

The result is:

Merge Cells Across in VBA

 

You may also like some of this related content...

Advertisements
Automate Excel
Left Menu Icon