Buck Beasom
asked on
Can I Create Cell Borders In Excel Using Late Binding
I want to put thin borders around certain cells in Excel, but I don't want the aggravation of using early binding.
Is there a way to do this?
Is there a way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
With oSheet.Range("B3:K7").Bord
.LineStyle = 1 ' xlContinuous
.Weight = 2 'xlThin
.ColorIndex = -4105 'xlAutomatic
End With
With oSheet.Range("B3:K7").Bord
.LineStyle = 1 ' xlContinuous
.Weight = 2 'xlThin
.ColorIndex = -4105 'xlAutomatic
End With
With oSheet.Range("B3:K7").Bord
.LineStyle = 1 ' xlContinuous
.Weight = -4138 'xlMedium
.ColorIndex = -4105 'xlAutomatic
End With
With oSheet.Range("B3:K7").Bord
.LineStyle = 1 ' xlContinuous
.Weight = 2 'xlThin
.ColorIndex = -4105 'xlAutomatic
End With