HELP - Modifying where solutions are sent/placed!

Hi,

I have a script for an equation that incrementally increases an input from a specified minimum to maximum, it then places the answers in a list in a column on the same worksheet.

It produces 5 unique solutions. I wish to modify the script so that it places each solution in the worksheet 3 times.

Currently the answers list as follows:
0.0000005
0.0000055
0.0000105
0.0000155
0.0000205

However, I require them to be listed as follows:

0.0000005
0.0000005
0.0000005
0.0000055
0.0000055
0.0000055
0.0000105
0.0000105
0.0000105
0.0000155
0.0000155
0.0000155
0.0000205
0.0000205
0.0000205

How can the following script be modified to do so?

Please Login or Register  to view this content.

Thanks,
HU

Please Login or Register  to view this content.

Apologies, this is the script I meant to originally post.

Sample before and after worksheets attached. All irrelevant information has been omitted. The 'before' file has been saved as an .xlsm and includes the macro in question. The 'after' worksheet only includes what I wish the macro to produce.

This solves that particular issue.

On a related note, how would it be modified further so that the solutions this time were ordered as follows:

0.0000005
0.0000055
0.0000105
0.0000155
0.0000205
0.0000005
0.0000055
0.0000105
0.0000155
0.0000205
0.0000005
0.0000055
0.0000105
0.0000155
0.0000205


Thanks in advance.

Thanks again kev!