Excel cell border apply

Hello All,

thank in Advance,

Need help for cell border apply to excel range(“A7:V100”)

Ram Gurav


How about the following post?


Hi @Ram_Gurav1

Sub ApplyCellBorders()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets(“YourSheetName”) ’ Replace “YourSheetName” with the actual sheet name

With ws.Range("A7:V100").Borders
    .LineStyle = xlContinuous
    .Color = vbBlack
    .Weight = xlThin
End With

End Sub

thank you so much sir

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.