View Single Post
  #1   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Durbien,

There are only 4 available line weights for line weight for borders. If you
want heavier, then you will need to draw your own lines over the borders and
use code like

ActiveSheet.Shapes.AddLine(Range("A10").Left, _
Range("A10").Top, Range("F10").Left, _
Range("F10").Top).Select
Selection.ShapeRange.Line.Weight = 5#

To put a heavy line above A10:E10.

HTH,
Bernie
MS Excel MVP



"durbien" wrote in message
...
I need to copy a table into an AutoCAD drawing and have the lineweights of
the table match a previously drawn line. The three thicknesses of lines
given
in the Borders toolbar are not enough - I need to access the thicknesses
in
the Line Style list - how do I do this?