Borders.LineStyle = ?options?

[AT--o]

Hi
Excel 2007


For

Application.ThisCell.Borders.LineStyle =

What are my = options?

 

[Mr_Roscoe]

From previous posts:

go into VBA, press F2 to view the object browser.
Type xlLineStyle in the box with the cursor and then press enter
xlContinuous
xlDash
xlDashDot
xlDashDotDash
xlDot
xlDouble
xlLineStyleNone
xlSlantDashDot

or refer to
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

 

[mikerickson]

VBEditor Help says to consult the Object Browser with the keyword xlLineStyle.

 

[AT--o]

No items found

 

[mikerickson]

Was XLLINESTYLE spelt correctly?

 

[AT--o]

Ok, now it works.