Hi,

I'm testing my excel program:

It is a set of data tables that can be extended or shorten.

E.G:

User enter 10:
1 calculations
2 .
3 .
4 .
5 .
6 .
7 .
8
9
10 calculation

Then if the user entered 3 or 15 for example:

It shortens or lengthens respectively...




I've set the conditions already so it can be extended or shorten...

However this errors occur:

When i shorten it a #value error occur in some of the data tables at the end.
Then when i lengthen it a #ref error occur ?

Please help me....