Getting rid of one side a border?

[Shaun Allan]

In various sheets all based on the same 'look', cell M2 on
sheet named "Single" sometimes has a left hand border.
How can I get rid of this using code?

 

[Nigel]

Sheets("Single").Range("M2").Borders(xlEdgeLeft).LineStyle = xlNone

Cheers
Nigel

 

[Shaun Allan]

EXCELLENT! Thank you!

-----Original Message-----
Sheets("Single").Range("M2").Borders

(xlEdgeLeft).LineStyle = xlNone