| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for the border style of a range
Andreas,
Thank you for this! :-) Regards Pete "Andreas Maistmann" wrote: Hello, try activesheet.range("IssueRed").Borders.Weight = xlThick instead. The BorderAround Method seems only suitable for setting the border Properties, not for reading them. As far as I understand it, using the Borders property in the way I mentioned above, will only work, if the setting are the same for all Borders of the cell, otherwise you have to pick a specific border with one of the following constants: xlDiagonalDown, xlDiagonalUp, xlEdgeBottom, xlEdgeLeft, xlEdgeRight, xlEdgeTop, xlInsideHorizontal oder xlInsideVertical E.g. activesheet.range("IssueRed").Borders(xlEdgeBottom ).Weight = xlThick will check for the bottom border. Andreas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| border colors and style | Excel Discussion (Misc queries) | |||
| Change border style using VB | Excel Discussion (Misc queries) | |||
| Create new border style? | Excel Discussion (Misc queries) | |||
| Change default border style? | Excel Discussion (Misc queries) | |||
| Border style of Excel forms | Excel Programming | |||
Threaded Mode
