View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1531_] Rick Rothstein \(MVP - VB\)[_1531_] is offline
external usenet poster
 
Posts: 1
Default Excel 2002 - Borders(xlInsideVertical).LineStyle=xlcontinuous not working

Try it using Cells; something like this...

Worksheets("Sheet1").Range("C5:F8").Cells.Borders( xlInsideVertical).LineStyle
= xlContinuous

Rick


"Yajiv" wrote in message
...
I have excel 2002 running in my server.
I tried to format a sheet with macro.
The
sheet.range.borderaround xlcontinuous is working
but sheet.range.borders(xlinsidevertical).linestyle=xl continuous is
not working
is there any other way to do the above formatting?