LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How to force user function to recalculate

Hi, experts

Please, help me if you can.
Every time I change cell value on other worksheet than the one where
selfwritten function is called and if this cell rules any argument
calculation I'm getting 0.0 or #value. Once I put cursor into my function
calling cell and push enter it recalculates. What should I do to force it
recalculate automaticly?
I searched for my problem here and found that I should add Application.
Volatile.
It helped but only partly. Before I had to manualy recalculate (put curcor
and push enter) every cells callin my function. Now I need to do it only in
one cell and other on the same sheet recalculate.
Is it possible to recalculate my function when any cell in entire workbook
has been changed?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to force all of the cells in a worksheet to recalculate? LurfysMa Excel Programming 6 June 23rd 07 03:34 AM
VBA: Force wait until recalculate mr tom Excel Programming 3 May 4th 07 01:00 PM
Recalculate function Peter A[_4_] Excel Programming 2 June 23rd 06 07:21 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


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"