'选中的单元格左对齐 Selection.Merge With Selection .HorizontalAlignment = xlLeft End With
'合并选中单元格、水平居左、垂直居下(只要改变这几个属性,就可以灵活控制显示方式了) Public Sub MergeCellsLeftBottom() Selection.Merge With Selection .HorizontalAlignment = xlLeft .VerticalAlignment = xlBottom .MergeCells = True End With End Sub
64:00->'64:00这样Excel就不会自作聪明了
應該是這個屬性
Selection.Merge
With Selection
.HorizontalAlignment = xlLeft
End With
Public Sub MergeCellsLeftBottom()
Selection.Merge
With Selection
.HorizontalAlignment = xlLeft
.VerticalAlignment = xlBottom
.MergeCells = True
End With
End Sub