根据VBA中的公式误差/值设置变量

I am trying to calculate a sheet (set on manual calcs) continuously until there are no more errors. I have the following code below, but it appears that it does not recognize the variables I set, as the values for those variables are the result of a formula and not actually what is in the cell as a value. I saw another question on a somewhat related topic that used a worksheet function, but have been unable to see how I can fit it into my code. Usually if I run this process without VBA code, I do the manual calcs 5-6 times, but for the code I would like to be more accomodating. The rest of my code works, it is just this part that is messing up the process. I suppose I could just calc the sheet like I normally would on a loop for some arbitrary number of calcs, but if possible I would like it to calc only if the two errors below are present. See below for piece of code. I am trying to calculate a sheet (set on manual