Home > VBAUsefulCodes
Apply Borders to Specific Range of cells using VBA. Border Variations & Colours can be customized according to needs
Apply Borders to Excel Sheet
Apply Borders to Specific Range of cells using VBA. Border Variations & Colours can be customized according to needs
Sub apply_borders()
shtname = "Sheet1"
With ThisWorkbook.Sheets(shtname).UsedRange.Select
With Selection.Borders()
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End With
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts