| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove all borders from a range
I am using Office 2003 on Windows XP.
I recorded the code to remove ALL borders from a range and got the following: Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone Selection.Borders(xlEdgeBottom).LineStyle = xlNone Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone Is there a simpler code to just remove all the borders in a range of cells? If so, could you please post example code? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Range Borders (Cell Addresses) In VBA | Excel Discussion (Misc queries) | |||
| Borders for range | Excel Discussion (Misc queries) | |||
| Sorting a range loses formatted borders | Excel Discussion (Misc queries) | |||
| how do you remove borders | Excel Discussion (Misc queries) | |||
| Borders nor underline commands remove an unusual underline. ?? | Excel Discussion (Misc queries) | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
