| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem setting BorderArround LineStyle:=xlLineStyleNone
You have more wisdom than I do.
Thank You -- JC "JLGWhiz" wrote: Don't ask me why because I have no idea, but this syntax works for deleting the borders. Selection.Borders.LineStyle = xlLineStyleNone "jc" wrote: When running the following code: Selection.BorderAround LineStyle:=xlDouble Selection.BorderAround LineStyle:=xlLineStyleNone the first line sets the border around the selection to xlDouble the second line does nothing VB help says: "To clear the border, you must set the LineStyle property to xlLineStyleNone for all the cells in the range." Am I doing something wrong or is there a problem with EXCEL 2003. I know that I can set the individual borders (left, right, top, bottom) the problem that this causes for me is that when you do this it overrides the border on the neighboring cell: ie setting the right border overrides the left border on the cell to the right. JC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dotted Linestyle is not seen in Print of the excel | Excel Discussion (Misc queries) | |||
| Error LineStyle | Excel Programming | |||
| Error LineStyle property of Border Class | Excel Programming | |||
| What is fastest? "If .LineStyle < xlContinuous ..." or ".LineStyle = xlContinuous" ?? | Excel Programming | |||
| Range.BorderAround(xlLineStyleNone) | Excel Programming | |||
Hybrid Mode
