Frank Freese
asked on
VBA borders around all cells
Folks,
I am looking for a way to add borders around all cells using VBA for the range K3:L13. What I tried below doesn't seem to even give me the bottom edge.
I am looking for a way to add borders around all cells using VBA for the range K3:L13. What I tried below doesn't seem to even give me the bottom edge.
Range("K3:L13").Borders(xlEdgeBottom).LineStyle = XlLineStyle.xlContinuous
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Folks,
I wrote this and it worked! Surprised even myself.
Dim rng As Range
Set rng = Range("K3:L13")
With rng.Borders
.LineStyle = xlContinuous
.Color = vbBlack
.Weight = xlThin
End With
In fairness to all I'll distribute the points the points equally. I appreciate your response
I wrote this and it worked! Surprised even myself.
Dim rng As Range
Set rng = Range("K3:L13")
With rng.Borders
.LineStyle = xlContinuous
.Color = vbBlack
.Weight = xlThin
End With
In fairness to all I'll distribute the points the points equally. I appreciate your response
ASKER
thank you to all
Range("K3:L13").Borders(xl
Range("K3:L13").Borders(xl
Kevin