Hi,
I have a code that brings in specified inputs from a worksheet incrementally (Min, max, increment values specified). I.e min = 1, max = 5 & increm = 2 would result in 3 unique solutions as the output.
I also have a code that brings in a list of values that have been specified in a column on the same worksheet to an equation. I.e A list of 5 unique inputs would result in 5 unique solutions at the output.
My aim is to now incorporate both codes into one function so that I can bring in a range of inputs for one part of an equation, whilst also bringing in an incrementally rising input for another part of the same equation. For example, if i had a list of inputs in a column ranging from 1 to 5 (ie 1, 2, 3, 4, 5) and another input with a min value of 1, a max of 5 and increments of 2 (ie values of 1, 3, 5) I should get 15 individual solutions.
Any advise, tips, pointers or help with combining these codes will be much appreciated!
Here is the code that brings in inputs incrementally between a specific min & max.
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Here is the code that inputs a listed set of values from the worksheet column.
![]()
Please Login or Register to view this content.
Individually they both work as intended.
I have combined them as follows.
![]()
Please Login or Register to view this content.
This script does not produce any error messages, but it does not work as intended.
Any help will be very much appreciated.
Bookmarks