I am trying to get VB to format borders in an Excel sheet.
Why isn't the following code working?

Dim xlEdgeBottom
Dim xlDouble
Dim xlThick

xlEdgeBottom = 1
xlDouble = 1
xlThick = 1

Set Range1 = Sheet5.Range("A1", "C1")

With Range1.Borders(xlEdgeBottom)
.Linestyle = xlDouble
.Weight = xlThick
End With


Does anyone have any tips on links or other codes (border style, etc)

THX

Humty