Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i reduce the thickness of Border in Excel?
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 "Antony" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting border thickness | Excel Discussion (Misc queries) | |||
Change thickness of Border with Conditional Formating | Excel Discussion (Misc queries) | |||
How do I change the thickness of a border (3 sizes is not enough) | Excel Discussion (Misc queries) | |||
Border thickness varies when I paste Excel cells into Word. | Excel Discussion (Misc queries) | |||
Changing Border Thickness Throughout Document | Excel Discussion (Misc queries) |