rectidy my range error in excel

Posted by Oswaldlily under ASP.NET on 9/9/2011 | Points: 10 | Views : 1977 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	hi also set property aspcode borders also otherwise post ur full code. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts