How to process multiple Rows one by one

[Manan]

Hi Masters,
GoodMorning.

I have a requirement like below.
In Column A i have 20 entries from row A2 to A21. Now what i want is that i want to run a macro for all 20 entries one by one and store the result of processing in Column C from C2 to C21.

My Aim is not to click macro 20 times rather clicking the macro one time and then it does the whole task . Ca this be done through loop. Also as in future the entries can increase so do we have faster loop execution method.

 

[Nebu]

Hi:

This is fairly easy to do , but you will have to define what do you mean by the "result of processing"?

Thanks

 

[Hui]

You can use Data Tables to achieve that without any macro's
Refer to: http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/

If you want specific help please post a sample file

 

[Marc L]

Hi,

all I can tell with this kind of poor initial explanation is a loop is not
the fastest way (like a plane !) and don't forget Excel functions
are often faster than a pure VBA code ! Example in this thread …

See For Each statment in VBA inner help …​