Updating Values on Excel Worksheet While Macro Runs
<p>Some of the values on my excel sheet are affected during the process of running my macro. Based on those values, I would in turn get other values. 
For example:</p>

<p>1 0 1 0</p>

<p>0 1 1 0 </p>

<p>my last line should be a sum of the above lines (using the excel function on the worksheet =sum(...):</p>

<p>1 1 2 0  </p>

<p>I would like to find the minimum of this last line and update the above 2 lines to:</p>

<p>1 0 1 1</p>

<p>0 1 1 0</p>

<p>I have already gotten this process to work. However, when I loop it, the values are based on the existing values on the spreadsheet (does not change according to the process, hence the minimum value never changes). Is there an existing syntax or command that will allow me to update values WHILE the macro runs through the excel sheet so that my code is able to read the updated values instead? </p>

<p>Thank you. </p>