You have more wisdom than I do.

Thank You
--
JC


"JLGWhiz" wrote:

Don't ask me why because I have no idea, but this syntax works for deleting
the borders.

Selection.Borders.LineStyle = xlLineStyleNone



"jc" wrote:

When running the following code:
Selection.BorderAround LineStyle:=xlDouble
Selection.BorderAround LineStyle:=xlLineStyleNone
the first line sets the border around the selection to xlDouble
the second line does nothing
VB help says:

"To clear the border, you must set the LineStyle property to xlLineStyleNone
for all the cells in the range."

Am I doing something wrong or is there a problem with EXCEL 2003.

I know that I can set the individual borders (left, right, top, bottom) the
problem that this causes for me is that when you do this it overrides the
border on the neighboring cell: ie setting the right border overrides the
left border on the cell to the right.
JC