Specify the cell using an A1-style cell reference (A1CellReference) enclosed within quotations (“”). Description: Returns a Range object representing a cell within the merged cell you unmerge.Worksheet.Range('A1CellReference').UnMerge To unmerge cells with VBA, use a statement with the following structure: #2: Unmerge Cells VBA Code to Unmerge Cells The following GIF illustrates the results of executing this macro example. Worksheets('Merge Cells').Range('A5:E6').Merge The following macro merges cells A5 to E6 of the worksheet named “Merge Cells”. Description: Merges the cells represented by the Range object you specify in item #2 above to create a merged cell.Enclose the entire cell range address within quotations (“”). Separate FirstCell and LastCell using the range operator, a colon (:). Specify FirstCell and LastCell using an A1-style cell reference. Description: Returns a Range object representing the cell range between FirstCell and LastCell.VBA Construct: Worksheet.Range property.Description: Returns a Worksheet object representing the worksheet you work with.VBA Construct: Workbook.Worksheets property.Worksheet.Range('FirstCell:LastCell').Merge To merge cells with VBA, use a statement with the following structure: You can find additional VBA and Macro Tutorials in the Archives. Learn how to work with worksheets here.Practical VBA applications and macro examples:.

Learn about R1C1 and A1 style references here.The following VBA and Macro Tutorials may help you better understand and implement the contents below: References to VBA Constructs Used in this VBA Tutorial.VBA Code to Merge Cells Within a Row Based on Cell Value.#6: Merge Cells Within a Row Based on Cell Value.

VBA Code to Merge Cells Based on Cell Value.

Merge duplicate rows in excel 2007