1

I created a bug in a user-defined function that is called from a large number of cells on many tables in an Excel workbook (not the way I would design it, I just "inherited" it).

But now, I can't seem to get rid of the #VALUE errors in the cells referencing this VBA function.

Tried so far:

  • Calculation menu, "Calculate Sheet"
  • Saving, re-opening (this workbook is set to calculate before saving)
  • Setting the calculation mode to Manual and back again to Automatic
  • ActiveSheet.Calculate
  • Application.Calculate
  • Application.CalculateFull

The only thing that seems to work is editing each cell and just hitting Enter to reset each formula, or overwriting the formulas via copy/paste.

2 Answers 2

2

I figured it out as I was typing the question:

Application.CalculateFullRebuild
-1

There must be a better solution but you can simulate editing the cell by doing a replace of = with = across the whole tab.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .