How do I use HypExecuteCalcScriptEx properly?

I had a macro that replicated user's actions: it changed parameters in the form, updated some values, and submitted the form. Essentially, doing something like that:

    sts1 = HypSetActiveMember("Entity", Entity_POV)

    sts2 = HypSetActiveMember("Product", Product_POV)

<change values>

      X = HypMenuVSubmitData()

Entities and Products were kept in an Excel sheet:

The macro was taking them one combination at a time.

All Entity X / Product X intersections are valid; not all Entity X / Product Y intersections are. As a result, I can't just switch from, say Entity 1 / Product 1 intersection to Entity 2 / Product 2, because while doing that I will temporarily encounter a situation where I will have Entity 1 / Product 2 intersection, and this intersection may be invalid.