I need a macro for Excel that would create a table of results in a separate excel file when iteration is performed. The macro when initiated should first ask for? the range of cells that would be iterated, then ask for start value, end value and step for each cell from the range. Then I should be able to define where are the result cells. Finally I should ba able to define where I want the file with results to be saved. The spreadsheet that I will use it for is 400000 rows times 40 cells so there is a plenty of calculations to be done. I am aware it would be time consuming, but it is not a big problem. The iteration should not be limited by standard 32000 steps noramlly provided by excel.
When there is more then one cell in the range defined as input cells I want the macro to go through all combinations, like:
a=1;b=1;c=1
a=1;b=1;c=2
a=1;b=1;c=n
a=1;b=2;c=1
a=1;b=2;c=2
a=1;b=2;c=n
and so on...
I am using Windows Vista Professional 64bit, and Excel 2007