Function won't calculate until I click in Cell and press Enter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I created my own function which does work correctly. After doing some work,
the cells using this function are displaying #Value. Since the function did
work before and I did not change anything I was a bit worried.

Nothing did work until I just clicked in one cell containing the function
and pressed enter, and it works. Miracle! Since I don't like to click
hundreds of cells I would appreciate, if any of you guys encountered this
error before.

I am using Excel 2003 11.8134.8132 SP2
 
By clicking the cell and touching ENTER, your are forcing the function to
re-calculate.


Run this tiny macro to force complete re-calculation:

Sub kick_it()
Application.CalculateFullRebuild
End Sub
 
Back
Top