Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to apply a bottom border to only filled cells. Archives didn't
yield anything pertinent that I could find but I was able to figure which line style by recording the keystrokes. I need the hairline style on the bottom edge, if this is any help: Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End With Selection.Borders(xlEdgeRight).LineStyle = xlNone Thanks so much. :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste-linking cells from Excel leaves a border in PP | Charts and Charting in Excel | |||
Border at bottom of worksheet | Excel Discussion (Misc queries) | |||
Repeat bottom Border | Excel Discussion (Misc queries) | |||
Apply Border | Excel Programming |