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

**Dave Sell** · Apr 23rd, 2004, 12:33 PM

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

**jmahaffie** · Apr 23rd, 2004, 12:59 PM

instead of

Code:

Range.BorderAround

try using

Code:

Range.Borders(xlEdgeLeft)

hope this helps

**Dave Sell** · Apr 26th, 2004, 01:53 PM

Thanks!

That did the trick!

Dave

**Dave Sell** · Apr 29th, 2004, 08:53 AM

How do I make this thread "Resolved"?

**jmahaffie** · Apr 29th, 2004, 08:59 AM

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.

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