Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
Apply bottom border only on filled cells, leaves blank cells without border? | Excel Programming | |||
Border help | Excel Programming | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Border | Excel Worksheet Functions |