Good Afternoon All,
I'm trying to add a top border to Columns L through N after filtering on Column "B" and customize to just the rows that appear with "Total" in its name.
The problem is, it will INSERT 3 new columns THEN add the Top-border to the rows as opposed to the already in place L through N columns
How can I just have it add the top border to the range of L through N on all rows that contain the word "Total"?
'Filter on "Total" and add borders
Range("B1").Select
Selection.Autofilter
Selection.Autofilter Field:=2, Criteria1:="=*Total*", Operator:=xlAnd
Range("L:N").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
Selection.Autofilter
End With
EDIT:
Found the problem :-)
Bookmarks