First of all, a big thanks to thinktank for saving my life with the Simpson's Rule code.


Another problem, which probably isn't all that difficult.....

I'm writing a program where I'm calculating values and printing out the list of answers in Excel. A very basic example: I might have a=40, b=20 and step=2. Then for, say, 10 times, multiply a *b, reducing a by the step each time. (40*20, 38*20, 36*20 etc.) I then print these answers out in a list in Excel. For this, I just created a simple loop, i=1 to 10, etc. Now, I need to call another subroutine to make a further more complicated calculation each time. What is the syntax for this? I found a different piece of code which has the line calc.RDC, where RDC is the name of the subroutine. Is there any other syntax? And in the sub-routine, do you need any return line or anything? This is a bit long-winded but any help would be great...