Modify macro to process multiple data

Hello,

I am using the following macro which was created by user jindon. When I run the macro a pop-up window appears where I select the data range, and then another pop-up window where I select where I want to output the results. Is it possible for the macro to be modified so that, I can select a range of data then the output cell, then again select another range of data and its output cell, and again another range of data and the output cell and so on... Since I have tens of ranges of data in many multiple sheets, my aim is to be able to select all accordingly and leave excel processing during the night.

This is the macro

Please Login or Register  to view this content.

Thank you,
Sans

You can use a collection:

Please Login or Register  to view this content.

That's exactly what I needed, thank you very much wallyeye! Is the process of selecting data and the results unlimited, that is until I close the window? Thank you

As far as I know, or at least you would have serious carpal tunnel by the time it ran out.

Excellent, thanks!

The above works great but I was wondering if it would also be posssible to select all the desired ranges in one sheet but when running the macro to process the same ranges over all sheets in the workbook. Thank you

You can tweak the code a bit:

Please Login or Register  to view this content.

I don't have a good way to test this, but it should get you close.

Thank you wallyeye. I'll give it a try!