Apply bottom border only on filled cells, leaves blank cells without border?
- From: StargateFan <IDon'tAcceptSpam@IDon'tAcceptSpam.com>
- Date: Sat, 07 Apr 2007 22:45:28 -0400
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
.
- Follow-Ups:
- Re: Apply bottom border only on filled cells, leaves blank cells without border?
- From: Debra Dalgleish
- Re: Apply bottom border only on filled cells, leaves blank cells without border?
- From: StargateFan
- Re: Apply bottom border only on filled cells, leaves blank cells without border?
- From: Helmut Weber
- Re: Apply bottom border only on filled cells, leaves blank cells without border?
- Prev by Date: Re: Help with "If" function?
- Next by Date: Save work*** as new workbook
- Previous by thread: Re: Toughy...
- Next by thread: Re: Apply bottom border only on filled cells, leaves blank cells without border?
- Index(es):
Loading