Getting rid of one side a border?

  • Thread starter Thread starter Shaun Allan
  • Start date Start date
S

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?
 
Sheets("Single").Range("M2").Borders(xlEdgeLeft).LineStyle = xlNone

Cheers
Nigel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Border formatting row of cells 22
Counting Bordered Cells 5
Conditional borders 3
Formatting borders 8
Turning into normal proportions 1
Exclude sheets from code 3
Problem copying named range 3

Back
Top