how to use range borders in excel

Posted by Oswaldlily under ASP.NET on 9/13/2011 | Points: 10 | Views : 1691 | Status : [Member] | Replies : 0
With xlApp.ActiveSheet.Range("A1:C11")
here i mentioned as 1-11 (i.e) 11 rows

But wht i doin has unknown number of rows means
at particular time v ll add new row /delete some row..
so row length not constant..
In this case,
How to use range???
Is t like.
for i as integer=1 to ds.tables(0).rows.count
j=3
Const xlEdgeTop = 8
Const xlEdgeBottom = 9
Const xlEdgeRight = 10
With xlApp.ActiveSheet.Range("Ai")
.BORDERS(xlEdgeLeft).Weight = 2
.BORDERS(xlEdgeTop).Weight = 2
.BORDERS(xlEdgeBottom).Weight = 2
.BORDERS(xlEdgeRight).Weight = 2
End With
next




Responses

(No response found.)

Login to post response