Excel cell border apply

Help Studio
, ,
1

Hello All,

thank in Advance,

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

image
image1810×502 37.8 KB

Regards,
Ram Gurav

2

Hi,

How about the following post?

Regards,

How to set background color to particular range and set border to complete sheet using VB.net as office is not installed in my machine
3

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

4

thank you so much sir

1 Like
5

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