Borders
 

I know I can add a border to a cell like this
myCell.BorderAround LineStyle:=xlContinuous, Weight:=xlThin, _
ColorIndex:=xlColorIndexAutomatic

but how do I remove it?

Sandy

Borders
 

myCell.Borders.LineStyle = xlNone
--
HTH...

Jim Thomlinson


"Sandy" wrote:

I know I can add a border to a cell like this
myCell.BorderAround LineStyle:=xlContinuous, Weight:=xlThin, _
ColorIndex:=xlColorIndexAutomatic

but how do I remove it?

Sandy

Borders
 

On May 8, 10:01 am, "Sandy" wrote:
I know I can add a border to a cell like this
myCell.BorderAround LineStyle:=xlContinuous, Weight:=xlThin, _
ColorIndex:=xlColorIndexAutomatic

but how do I remove it?

Sandy

Sandy

Try

myCell.BorderAround LineStyle:=xlNone

Ken

Borders
 

Did you try that code? It didn't work for me...
--
HTH...

Jim Thomlinson


"Ken" wrote:

On May 8, 10:01 am, "Sandy" wrote:
I know I can add a border to a cell like this
myCell.BorderAround LineStyle:=xlContinuous, Weight:=xlThin, _
ColorIndex:=xlColorIndexAutomatic

but how do I remove it?

Sandy

Sandy

Try

myCell.BorderAround LineStyle:=xlNone

Ken

Borders
 

It didn't work for me either - which is why I threw it out to you guys. Your
solution however does work Jim - thank you
Sandy

"Jim Thomlinson" wrote in message
...
Did you try that code? It didn't work for me...
--
HTH...

Jim Thomlinson


"Ken" wrote:

On May 8, 10:01 am, "Sandy" wrote:
I know I can add a border to a cell like this
myCell.BorderAround LineStyle:=xlContinuous, Weight:=xlThin, _
ColorIndex:=xlColorIndexAutomatic

but how do I remove it?

Sandy

Sandy

Try

myCell.BorderAround LineStyle:=xlNone

Ken