Insertion and Deletion of rows programatically

[Savita]

Hi,

Facing the foll. issue while programming in excel.Pls help.

1)There are two sections of data having 15 rows each in the worksheet.One has forecast sales data and the other has actual sales data.
2)User selects a cell in the first section.Say the row number of this cell is 5.
3)We have to write a macro which inserts a row after row number 5 in section 1 and also after row5 in section 2.
4)We are able to insert row in section1 but not in section 2.

Savita

 

[unmarkedhelicopter]

So where is section 2 ?

 

[Savita]

Section2 is below section 1 on the worksheet.

 

[unmarkedhelicopter]

So how (programatically) do I find section 2 ?
Is there a gap between section 1 and section 2 ?
What does the data look like ?
Can you construct a mock up and attach that ?