clear all borders using VBA

[bjr157]

is there a way to clear all borders of a range rather than using code that looks like this:

Selection.Borders(xledgeright).LineStyle = xlNone
Selection.Borders(xledgeleft).LineStyle = xlNone

etc...

it also would need to clear the border "in the middle" of a large square range.

thanks for any help you can give me

 

[JohnG]

try like this

Range("A1:N12").Borders(xledgeright).LineStyle = xlNone
Range("A1:N12").Borders(xledgeleft).LineStyle = xlNone

 

[Travis]

You should be able to clear all boarders with just this one line. Is that what you are trying to do?

Selection.Borders.LineStyle = xlNone

 

[bjr157]

yes, thats exactly what i needed, thanks.