How do i reduce the thickness of Border in Excel?

I want to reduce the thickness of the border line in the excel, I want to
create a line thickness less than one point.

Please do suggest me how do I write that macro for Excel in VB.

Here are some I use. Weight can be xlthin,xlmedium, or xlthick

Sub unborder()
Selection.Borders.LineStyle = xlLineStyleNone
End Sub
Sub borderdo() 'Next one is better
With Selection.Borders
..LineStyle = xlContinuous
'.Weight = xlMedium
End With
End Sub
Sub borderoneline()
Selection.Borders.LineStyle = xlContinuous
End Sub

--
Don Guillett
SalesAid Software
donaldb@281.com
"Antony" <Antony@discussions.microsoft.com> wrote in message
news:926E6EE0-87BD-4E75-A0A7-96FFCC0A672A@microsoft.com...
> I want to reduce the thickness of the border line in the excel, I want to
> create a line thickness less than one point.
>
> Please do suggest me how do I write that macro for Excel in VB.
>
>

This will change the border thickness of the activecell

Please Login or Register  to view this content.