mrtauntaun
MIS
Hi there. Im new to using VBA in excel, so bear with me.
I have a workshet with numerous rows. I need to make a snipet of code that checks a row, takes the values from a cell, runs it through a formula, and puts it in a cell at the end of a row. Once it is done, the have it do so for the next row and so on until each row is done. At which point have it terminate.
For example, for row 1:
Take value from Cell A1, place the result of formula (8-A1)*10 into cell E1. Proceed to next row, using cells A2 and E2.
I hope that is clear. Thanks!
I have a workshet with numerous rows. I need to make a snipet of code that checks a row, takes the values from a cell, runs it through a formula, and puts it in a cell at the end of a row. Once it is done, the have it do so for the next row and so on until each row is done. At which point have it terminate.
For example, for row 1:
Take value from Cell A1, place the result of formula (8-A1)*10 into cell E1. Proceed to next row, using cells A2 and E2.
I hope that is clear. Thanks!