Recalculate function

  • Thread starter Thread starter Peter A
  • Start date Start date
P

Peter A

Hi
I have a function in a spreadsheet defined in Visual Basic. Is there a way
to get cells containg this function to be recalculated after data has been
changed? It doesn't happen automatically and F9 has no effect. So far, the
only way I can find to get the correct value calculated is to re-enter the
formula in the cell.

Thanks for any tips
 
Add Application.Volatile at the start.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Yes, Bob, it did help. Thanks very much.
Peter

Bob Phillips said:
Add Application.Volatile at the start.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

force recalculation of function 5
avoid recalculating user-defined function when file opened 2
Recalculation Failure 1
Functions not firing! 2
Force Recalc 3
User Function Not Recalculating 5
Volatility, recalculation 7
recalculation of a custom function in excel 4

Back
Top