Hi all
I have wriiten a program with help from my fren and some bros in here
This program calculates the values of geometrical properties of a
arbitrary section, drawn by straight lines on chart form, and th
co-ordinates corresponding to the points will be shown on a table.
This program is such that the user chooses the number of co-ordinat
points, and maths operations will be carried out to solve for the tota
perimeter and area of the enclosed area. Now i have a problem, fo
example, if i have already decided on the number of co-ordinate points
the maths operations only performs for the given number. if i choose t
add a few co-ordinate points in between the originally chosen points
the maths operations does not include these points into calculations
How do i solve this?
I know this sounds a bit vague, so let me pose a scenerio. For example
when i open my excel file, the 1st worksheet prompts the user to choos
the number of co-ordinate points. Initially i choose 20 points, so th
programs gives me 20 points to play with. Associated with these 2
points, maths is done. Now, i decide to add one more point between th
11th and 12th co-ordinate, thus making the total number of co-ordinat
points now 21.
1st question : How can i add a new row to insert these values? (i kno
by right click on the 11th co-ordinate on the table, and choose "inser
row", but this doesnt work for the maths )
2nd question : How can i get the program to include the new values int
its calculations?
If any bro can understand (vaguely) what i am trying to ask, pleas
help!
Post ur doubts about my question, and i try to explain more clearly.
Thanks in advance
cigeratt
--
Message posted from
http://www.ExcelForum.com