Apply formula through a range of data

Hello,

I am extremely new at using VBA so I apologize if my problem seems trivial. I am trying to find a way to apply a formula through a range of data. I started off by applying the formula to single cells. How would I alter the code to apply to a range from B15:2514, C15:2514, D15:2514 and E15:2514 and to then display the final result in cells G15:2514?

Thank you in advance!

Please Login or Register  to view this content.

Try adding :Column Letter2514 to each range in the code. Ex.

Please Login or Register  to view this content.

Hmm....I'm missing something but not sure what. The code isn't working for me as I expected it to.

Maybe one way:

Please Login or Register  to view this content.

Regards, TMS

Or, if you want the formulae:

Please Login or Register  to view this content.

Regards, TMS

Or, if you want the values without the loop:

Please Login or Register  to view this content.

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thank you TMS! I messed up and added a loop at the end of the code. Guess what, it wouldn't STOP running, had to end task to get it to stop. And to think, I just told someone today that I know enough about VBA code to mess it up bad.

@meghs918: You're welcome. Thanks for the rep.

@gmr4evr1: You're also welcome. Thanks for the rep too.

The problem with your first attempt was that it simply puts the (same) calculated value in every cell in the range. So, you either need to loop through the range and output the value calculated for each iteration. Or, alternatively, just drop the formula into every cell. Note that the cell references will automatically adjust provided you start with the right entries. And, once you have that, it's a small step to convert all the formulae to values.


Regards, TMS

You're welcome, and thank you for the new information.
As long as I don't loop like I tried to, I should be ok.

It happens ... to us all