Hi,

My code involves dynamic creation of rows and columns.

The sheet that is to be developed is partly static and partly dynamic.

How do I incorporate the dynamic aspect without affecting the static portion.

example:

My worksheet actually has static as well as dynamic portion.

Depending on the user different number of rows are added.

These rows need to be inserted between the already present static rows.
Actually new cells have to be added to already present static rows.Depending on the number the cells are added to different rows.

For eg. If the user x adds 3 rows then cells are added to rows(1-5)
from cell index 6.
On the other hand if user y adds 8 rows the cells will be appended to rows(1-8) from cell index 6.

Is there any way of splitting the sheet from cell index 6.Then I can possibly add the new values to the second part of the sheet without affecting the other portion.