Add a new row in range

Hi,

I already have a range from row number A10 to A20..

How do I add a new row via code in the beginning and include in the range.

I have to insert a row before A10 and then include it in range via code.

so that after insertion my range refers A9 to A20

Any help?

Please Login or Register  to view this content.

Hi,

Yes it adds the row, However it get the format for the row 9.

I want to have the formatting properties of row 10 for this new added row?

How can do that?

Please Login or Register  to view this content.