Ah, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently

Ah, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently in its own column. Granted I'm one user out of many, and have switched to programming for any kind of quantitative work. but I'm still quite supportive of Excel.