Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
Hi Guys
I am selecting ranges and then want to automate adding Borders and BordersAround the selected range. When running the code, I have to call the macro twice to do BordersAround and Border on the selected cells. Looking for some help in order that I can call the macro once and get both.
I am selecting ranges and then want to automate adding Borders and BordersAround the selected range. When running the code, I have to call the macro twice to do BordersAround and Border on the selected cells. Looking for some help in order that I can call the macro once and get both.
VBA Code:
Sub Frame()
With Selection.Borders.LineStyle = xlContinuous
End With
With Selection.BorderAround.xlContinuous.xlThick
End With
End Sub