I've got some running around to do, so, it will be awhile.
But, for the constant area case, just place the formula in the height cell. However, instead of "w", use width. And, for simplicity, instead of "a", pick a numeric value. You probably should put a guard fcn around the formula to prevent it from getting clobbered.