Border
 

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

Border
 

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

"Maximus" wrote in message
ups.com...
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

Border
 

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

Border
 

On May 9, 3:27 pm, "Otto Moehrbach" wrote:
Range("C23 :G27").BorderAround LineStyle:=xlContinuous,
weight:=xlThick
HTH Otto

"Maximus" wrote in message

ups.com...



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!