| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
Hybrid Mode
