I keep getting a "Circular Reference" warning, but the cell specified has a "randbetween" formula. How the H-E-Double hockey sticks does that constitute a circular reference?
Depends on your formulas I guess. check out my reftreeanalyser tool, which will locate all active circular references: https://jkp-ads.com/reftreeanalyser.asp