Thread: Border Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Border Problem

Hey GS, you probably have to use xlInsideHorizontal.

"Gary''s Student" wrote:

In a worksheet, I have borders around cells C5 and E8 and F4 and each cell in
D15:G19.

When I run:

Sub next_tryx()
Range("A1:G19").Borders(xlEdgeBottom).LineStyle = xlNone
End Sub

The only borders that get cleared are the ones on the last row (D19:G19).

Why not the others?
--
Gary''s Student - gsnu200773