Posted to microsoft.public.excel.programming

Peter A[_4_] Peter A[_4_] is offline

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recalculate changes only	hmm	Excel Discussion (Misc queries)	3	December 18th 06 01:06 PM
Refresh/Recalculate a Custom Function	dch3	Excel Worksheet Functions	1	July 31st 06 01:59 PM
My VBA Function Won't Recalculate	soteman2005[_2_]	Excel Programming	3	December 1st 05 02:51 PM
function does not recalculate sum	lukiedukie	Excel Worksheet Functions	1	April 22nd 05 10:20 PM
Recalculate Custom Function	Brad L.	Excel Programming	3	May 20th 04 02:04 PM

All times are GMT +1. The time now is 01:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us