Quote:
Originally Posted by macropod
That's as simple as seleting the cells to merge, then using:
Code:
Sub Demo()
Selection.Cells.Merge
End Sub
It hardly seems worth the effort, though, as the same functionality is readily available on the Table Tools contextual Ribbon. |
Good point, maybe I’m aiming too low given that I’ve never used macros before. When I merge the cells, another issue is that they don’t merge nicely. There’s often an extra space between the two cells. Is there a way to remove this? And is there a way that I can also put the number in the second cell in brackets?