VBA to loop solver

Hi.
I am new to using VBA, apologies if this is very basic.... but I've been unsuccessful in implementing tips from other posts.

I have a column of 101 values on 4 sheets that I need to use SOLVER to calculate.

The formula is located in column F, the ouput I am solving for located in column E, and I am solving for 0.

When I record a macro, it looks like this

Please Login or Register  to view this content.

My question is, how do I create a loop/automate this so that after it finds a solution for row 52, it jumps to row 53 and does the same thing, all the way to row 151?

I have attached my full spreadsheet. The sheet I am using as an example is "Wheat HL"

I am using MS excel 2016, 32 bit.

I really appreciate any help!! I've had to manually run this several times already as other parameters in my model change

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

We have several examples of running Solver within loops here. A couple I keep handy:
Here's a fairly simple example of a loop: https://www.excelforum.com/excel-pro...ml#post4887763
Another: https://www.excelforum.com/excel-pro...ml#post4546973

Are you already familiar with VBA's (similar to other programming languages) loop structures? https://www.dummies.com/software/mic...xcel-2016-vba/