What is the VBA language to copy formula cell and apply formula to set of cells?

For my first attempt at coding it is pTotal = R * T / (v - b) - a / v ^ 2 but the way I have it set-up I will only get the final value when i=10 instead of getting values for each i in i=1 to n. If I knew how to insert the correct language then I would be about halfway to getting what I would like to have as a result.

For my second attempt, I didn't get to the point of inserting the pressure function. I was first trying to understand how to display T=0,25,50,.....500 in increments of 25 or, rather, in increments equal to stepsize which in my case will be 25.

Basically the pressure function will be the expression for which the other variable values will be translated into some value for which I would like to plot that corresponds to the T value which produced it.

I hope this helps. If not, then let me know and I will try to clarify what I mean. Thanks!

This VBA code may help you:http://www.worldbestlearningcenter.c...la-example.htm

@JapanDave Yes it is a homework assignment. I am not one to cheat in order to just get the answer without understanding but I understand your concern. The class I am taking is Numerical Methods for Engineers. Unfortunately, the class does not have programming as a prerequisite even though it is a requisite for completing the homework. I've read parts of the required textbook for examples etc and I've read the examples my professor posted for us to learn how to approach the problem. I've also have been reading a book entitled, "VBA for Excel Made Simple" by Keith Darlington but I've yet to come across the concepts that the problem appears to require. In truth, I don't want the specific answer to the problem but I think it would be beneficial if an example were offered which covered similar concepts. I really want to learn how to do this without a specific and direct answer because that would take away from the learning process. It's getting late here at the moment but I will take a look at what darayuk posted tomorrow morning and see if I can understand how to go about writing the proper code. (Thank You darayuk BTW). Any help in that manner will be appreciated. Thanks. :-)