I have attached a sheet. A walk thru of the sheet will best demonstrate my problem.
On tab "Blue", place a "1" into F10. A "1" will be evaluated into H10 by formula and in turn the vba code will make a "1" appear in I10. So far so good and this work all the time.
The code will also make a "1" appear in Tab "Red", w10. In turn a "1" will be evaluated into Tab "Red" Y10 by formula and in turn a "1" will appear in Tab Red z10....sometimes.
Repeating this process again tab "Blue" starting at say F14 everything will work again INCLUDING Red Z10, if it did not already get a "1" in it from before.
So I am not sure why the code works sometimes and does not work at other times.
As for the other code in the spread sheet putting "preini", "brains", and "basic" it is just there to show that something happens. This is just filler and not the focus of this question.
The question or goal is to figure out how to get the entire row of code to execute the first time and by itself without the help of other rows.
ALSO WHEN I isolate and test just the Red or Blue code by itself (i.e. either the Red runs and Blue is commented out or vice versa) the code works just fine. It just does not want to work together.
thanks for your help!