Sub CoupeCell()
Dim Tgl As Shape
With ActiveCell
With .Borders(xlDiagonalUp)
.LineStyle = xlContinuous
.Weight = xlHairline
.ColorIndex = xlAutomatic
End With
Set Tgl = ActiveSheet.Shapes.AddShape(8, .Left, .Top, .Width, .Height)
End With
With Tgl
.Flip 0
.Placement = xlMoveAndSize
With .Fill
.Visible = True
.Solid
.ForeColor.SchemeColor = 15
.Transparency = 0.7
End With
.Line.Visible = False
End With
End Sub