I am trying to create a border around a selection. I am currently
using

Range("C23:G27").Select
Selection.Borders.LineStyle = xlDouble

This results in borders throughtout every cell. How do I get a border
around the perimeter?

Thanks

Range("C23 :G27").BorderAround LineStyle:=xlContinuous,
weight:=xlThick
HTH Otto

"Maximus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am trying to create a border around a selection. I am currently
> using
>
> Range("C23:G27").Select
> Selection.Borders.LineStyle = xlDouble
>
> This results in borders throughtout every cell. How do I get a border
> around the perimeter?
>
> Thanks
>

Range("C23:G27").BorderAround LineStyle:=xlDouble

There's more options for .borderaround that you may want to read about in VBA's
help.

Maximus wrote:
>
> I am trying to create a border around a selection. I am currently
> using
>
> Range("C23:G27").Select
> Selection.Borders.LineStyle = xlDouble
>
> This results in borders throughtout every cell. How do I get a border
> around the perimeter?
>
> Thanks

--

Dave Peterson

On May 9, 3:27 pm, "Otto Moehrbach" <ottokm...@comcast.net> wrote:
> Range("C23 :G27").BorderAround LineStyle:=xlContinuous,
> weight:=xlThick
> HTH Otto
>
> "Maximus" <mwago...@caldrywall.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >I am trying to create a border around a selection. I am currently
> > using
>
> > Range("C23:G27").Select
> > Selection.Borders.LineStyle = xlDouble
>
> > This results in borders throughtout every cell. How do I get a border
> > around the perimeter?
>
> > Thanks- Hide quoted text -
>
> - Show quoted text -

Outstanding Thanks!