To put a Border on 1 side of a Cell [resolved]

Hi,

Anyone know how to put a border on just 1 side of a Cell programatically?

I have a VB program formatting ranges and I am using the

VB Code:

Range.BorderAround ..,..,..,..

Member, but that places a border on all sides. I just want 1 side.

Is there a way?

Thanks!

Dave

instead of

Code:

---

Range.BorderAround

---

try using

Code:

---

Range.Borders(xlEdgeLeft)

---

hope this helps

Thanks!

That did the trick!

Dave

How do I make this thread "Resolved"?

Quote:

---

Originally posted by Dave Sell
How do I make this thread "Resolved"?

---

not sure, but i'd assume just click the EDIT button on your original post and change the title by putting the RESOLVED word in front of it. later.