Option Explicit
Sub Macro1()
With Range("B2:B6")
.Merge
.HorizontalAlignment = xlCenter
.BorderAround LineStyle:=xlContinuous
.WrapText = True
End With
End Sub
Option Explicit
Sub Macro1()
With Range("B2:B6")
.Merge
.HorizontalAlignment = xlCenter
.BorderAround LineStyle:=xlContinuous
.WrapText = True
End With
End Sub
Option Explicit
Sub Macro1()
Application.DisplayAlerts = False
With Range("B2:B6")
.MergeCells = True
.HorizontalAlignment = xlCenter
.BorderAround LineStyle:=xlContinuous
.WrapText = True
End With
Application.DisplayAlerts = True
End Sub
Option Explicit
Sub Macro1()
With Range("B2:B6")
Application.DisplayAlerts = False
.MergeCells = True
Application.DisplayAlerts = True
.HorizontalAlignment = xlCenter
.BorderAround LineStyle:=xlContinuous
.WrapText = True
End With
End Sub