Hi,

I want to table apply border for particular range in excel using VB script.

Please help

Have you tried recording a macro?

How can i do that.

Could u explain????

with ActiveCell.Borders
.Color = RGB(0,0,0)
.Item(xlEdgeTop).Weight = xlThick
.Item(xlEdgeLeft).Weight = xlThick
.Item(xlEdgeBottom).Weight = xlThick
.Item(xlEdgeRight).Weight = xlThick
End with




for specific range :
Range("a1", "b10").Borders.Weight = xlThick