endnumber

Note: This was originally posted at https://www.excelforum.com/excel-programming-vba-macros/1274124-help-with-arrays.html I have not been able to get any responses to addressing this. My apologies if this doesn't make sense, I am new to using arrays and have been trying to research this but...

First, I have the code below. When I run this, a new spreadsheet is created as expected. When the data is placed on the new spreadsheet, it puts all of the selected values that I am trying to solve for (A2 to A134) instead of just the solver results, 6 of the values as determined by Solveradd...

I am trying to create a loop that uses a variable as the end number. This number can range from 1 to 200. Below is what I created. I have tried a variety of variations but I cannot figure out how to get this to work. Any Ideas? 'Loop - Number of times to run - 1 to EndNumber Dim...