If ActiveSheet.Range(Cells).Count > 1 Then "For Example: To Enter a Range A1 to A3 type A1:A3 ") If you wish to merge cells using a VBA program then you should try the below codes:Ĭells = InputBox( "Enter the range of cells that you wish to merge." & vbNewLine & _
#UNABLE TO MERGE AND CENTER IN EXCEL 2013 HOW TO#
Method 3: How to Merge cells in Excel using VBA Macro: Now, in the “Format Cells” window navigate to the “Alignment” tab and check the “Merge” checkbox and click “Ok”.
![unable to merge and center in excel 2013 unable to merge and center in excel 2013](https://xltools.net/static/33101f5b7aef38ab208f6525d95409e7/d4a45/Merge-cells-into-single-cell.png)
Recommended Reading: Concatenate Cells in Excel On the other hand, Concatenation is the process of joining or combining the values from two or more cells.
![unable to merge and center in excel 2013 unable to merge and center in excel 2013](https://images.wondershare.com/recoverit/article/2019/11/discard-changes-and-save-excel-file.jpg)
As I have foretold, Merging is the process of taking two or more cells and constructing a single cell out of them. Many times people confuse between these two words. How Merging is different from Concatenation?
![unable to merge and center in excel 2013 unable to merge and center in excel 2013](https://legalofficeguru.com/wp-content/uploads/2019/04/Excel-2019-format-cells-align-wrap.png)