excel vba array problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: adamstn2 (adamstn2.152ott_at_excelforum-nospam.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 12:11:55 -0500

hi all,
i am working on a semster project for a class where i have to write a
program. this is what i want my program to do i want to ask a user to
enter in 11 x values and 11 y values evenly spaced. then i my program
to make a graph of the inputted values. and finally i want to give the
user the option of how they want to find the area under the curve by
using simpons rule, the trapezodial rule, midpoint rule, and reimanns
sum.

my problem is that i want to take the 11 x and y values that the user
entered in and display them in an excel work***. i thought i could
put the entered values into an array and then display that array in an
excel work*** but i am running into problems. also i am using a for
loop to ask the user 11 times to enter an x value and i am using a
seperate for loop to ask the user 11 times to enter a y value. these
are the numbers that i am trying to get into a array and displayed into
an excel work***.

if anyone can help me or give me some helpful tips please do so.

thank you
adamstn2 

---
Message posted from http://www.ExcelForum.com/
Quantcast