JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 180
- Office Version
- 2021
- Platform
- Windows
I have a range of cells, I'm trying to set Borders Around the rangs, Line Style = Dash, Weight = Thin, and Color = black.
I've tried different things, but I keep getting an error.
With Worksheets("Sheet1").Range("D9:L20").BorderAround
.LineStyle = xlDash
.Weight = xlThin
.ColorIndex = 1
End With
I've tried different things, but I keep getting an error.
With Worksheets("Sheet1").Range("D9:L20").BorderAround
.LineStyle = xlDash
.Weight = xlThin
.ColorIndex = 1
End With