BorderAround won't go away
The VBA help instructions are misleading. The correct syntax should be
Range("C3:G8").Borders.LineStyle = xlNone
"JLGWhiz" wrote:
Can someone explain why I still have a xlThick border around my range after I
run this procedu
Sub brdrs()
Range("C3:G8").BorderAround Weight:=xlThick, _
ColorIndex:=xlColorIndexAutomatic
MsgBox "Check Border"
Range("C3:G8").BorderAround LineStyle:=-4142
Range("C3:G8").BorderAround LineStyle:=xlLineStyleNone
Range("C3:G8").BorderAround LineStyle:=xlNone
End Sub
|