ActiveX- Excel- Adding top and bottom border

[mprogram]

Hi,

I'm trying to add a border to a range of cells in excel by the mean of activeX. I need to add only the top border and the bottom one.

I have tried using the selection property contained in Globals. I have also tried creating a style in the current excel Workbook but I do not know how to make it work.

I can only create a border arround all the range using AroundBorder.

Thanks by forehand

[Michael_Munroe]

You do not need to use the style or the selection property to apply the borders to specific edges of the range. Just use the Item Method to specify which one you want to modify.

Method Worksheet->Range
Property Range->Borders
Method Borders->Item(xlEdgeTop)
Property Border->Weight = xlThin

Attached is you VI modified as described.

Michael Munroe
Certified LabVIEW Developer
www.abcdef.biz