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....
Bookmarks