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

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

--
Gary''s Student - gsnu200732


"BoromirOfGondor" wrote:

> 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