Borders

[Sandy]

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

 

[Guest]

myCell.Borders.LineStyle = xlNone

 

[Ken]

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

 

[Guest]

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

 

[Sandy]

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