Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear BorderAround in VBA
2003
VBA offers a shortcut to add borders around a range like: Worksheets("Sheet1").Range("B1:D1").BorderAround ColorIndex:=3, _ Weight:=xlThick But to remove the border it appears that only the following works: With Worksheets("Sheet1").Range("B1:D1") .Borders(xlDiagonalDown).LineStyle = xlNone .Borders(xlDiagonalUp).LineStyle = xlNone .Borders(xlEdgeLeft).LineStyle = xlNone .Borders(xlEdgeTop).LineStyle = xlNone .Borders(xlEdgeBottom).LineStyle = xlNone .Borders(xlEdgeRight).LineStyle = xlNone .Borders(xlInsideVertical).LineStyle = xlNone .Borders(xlInsideHorizontal).LineStyle = xlNone Endwith The VBA documention mentions: "To clear the border, you must set the LineStyle property to xlLineStyleNone for all the cells in the range." But that does not work as stated. In fact, it errors out Object. Is there a shortcut BorderAround Clear or is the 8 step process above the only way? TIA Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Button | Excel Discussion (Misc queries) | |||
excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
Using control to clear spreadsheet | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions |