rectidy my range error in excel

Posted by Oswaldlily under ASP.NET on 9/9/2011 | Points: 10 | Views : 1180 | Status : [Member] | Replies : 1
when I add new row table border should extend automatically..


*For the following code, border is only for 10 rows...
With xlApp.ActiveSheet.Range("A1:D10")
.BORDERS(xlEdgeLeft).Weight = 2
.BORDERS(xlEdgeTop).Weight = 2
.BORDERS(xlEdgeBottom).Weight = 2
.BORDERS(xlEdgeRight).Weight = 2
End With

If i add row from asp page,border still ll be in 10th row..
I expect dt border shd come to 11th row




Responses

Posted by: Jayakumars on: 3/19/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
also set property aspcode borders also

otherwise post ur full code.

Mark as Answer if its helpful to you

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response