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?
|