VBA - How to Clear ONLY bottom border of Rows in a range?

[HDEmpsall]

I can set a border with:

Dim rnge3 as Range
Dim rowstart as Integer, rowend as Integer

set rnge3 = Worksheets(3).Range("A" & rowstart & ":AU" & rowend)
With rnge3.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 3
End With

But when I want to clear that border, using .LineStyle = .xlLineStyleNone fails, as does .xlNone.

I do NOT want to clear vertical borders, NOR ANY borders from the top (heading) rows of the sheet.
Many of my attempts fail to compile. The attempts that compile fail to work!

 

[HDEmpsall]

Yes - that's what I had thought you wanted, hence my confusion.

Yes. I apologise.
I had got fixated on the procedure to write the border. This is done when 1 record is written, so I want a bottom edge border then.
When the sheet is cleared I need to clear the borders from many individually-written records, so I need to get rid of the old borders before new are written. So for the border-cleanup I need all the horizontal lines.