If using 2003 or newer check out DataListCreate List.

Allows you to insert rows within a list area without affecting rows to left
or right of the list area,

Will, however, affect rows below your list area.


Gord Dibben MS Excel MVP

On Sat, 29 Nov 2008 10:10:01 -0800, antares
wrote:

Dear All,
Hello... I have the following issue....
I have an excel sheet where on the left side of the sheet there is a list of
people. On the right side I have list of activities...so if I want to add
some other activity I have to insert new row... but in this case list of
people also gets new row... so how can I manage to vary the number of raws
for activitiesd and at the same time haveing list of people not touched ?