BadBoyCholette
New member
- Joined
- Feb 18, 2004
- Messages
- 2
I know that the following line add a border to the Left of the "O4" cells.
xclWorkSheet.Range("O4").Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlContinuous
But does anyone knows whats the line to get the actua border, because in my application I dont want to remove the border if they are already remove, so how can I know whats the actual border. Ive tried a if, but it didnt work.
If xclWorkSheet.Range("C2").Borders.Value = Excel.XlLineStyle.xlLineStyleNone Then
Ive tried
If xclWorkSheet.Range("C2").Borders(Excel.XlBordersIndex.xlEdgeLeft).Value = Excel.XlLineStyle.xlLineStyleNone Then
And its still doesnt work, when I replace the = with a IS, .Net tell me that Excel.XLineStyle.xlLineStyleNone is not a reference type, can anyone help me there?
Thank you.
xclWorkSheet.Range("O4").Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlContinuous
But does anyone knows whats the line to get the actua border, because in my application I dont want to remove the border if they are already remove, so how can I know whats the actual border. Ive tried a if, but it didnt work.
If xclWorkSheet.Range("C2").Borders.Value = Excel.XlLineStyle.xlLineStyleNone Then
Ive tried
If xclWorkSheet.Range("C2").Borders(Excel.XlBordersIndex.xlEdgeLeft).Value = Excel.XlLineStyle.xlLineStyleNone Then
And its still doesnt work, when I replace the = with a IS, .Net tell me that Excel.XLineStyle.xlLineStyleNone is not a reference type, can anyone help me there?
Thank you.