I meant to add... the idea being that without "Cells", Borders refers to the
border around the specified range; with "Cells", Borders refers to the
border around individual cells within the range.
Rick
"Rick Rothstein (MVP -
VB)" wrote in
message ...
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?