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

--
Peter Aspey
E-mail: replace 6 by p

Add Application.Volatile at the start.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter A" wrote in message
...
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

--
Peter Aspey
E-mail: replace 6 by p

Yes, Bob, it did help. Thanks very much.
Peter

"Bob Phillips" wrote in message
...
Add Application.Volatile at the start.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter A" wrote in message
...
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

--
Peter Aspey
E-mail: replace 6 by p