Savita
10-01-2007, 02:37 AM
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
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