ExcelBanter - Getting rid of one side a border?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Getting rid of one side a border? (https://www.excelbanter.com/excel-programming/304933-getting-rid-one-side-border.html)

Shaun Allan

Getting rid of one side a border?

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

Getting rid of one side a border?

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

Cheers
Nigel

"Shaun Allan" wrote in message
...
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?

Shaun Allan

Getting rid of one side a border?

EXCELLENT! Thank you!

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

Cheers
Nigel

"Shaun Allan" wrote
in message
...
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?

.

All times are GMT +1. The time now is 12:29 PM.