View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter A[_4_] Peter A[_4_] is offline
external usenet poster
 
Posts: 2
Default Recalculate function

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