Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to force all of the cells in a worksheet to recalculate? | Excel Programming | |||
VBA: Force wait until recalculate | Excel Programming | |||
Recalculate function | Excel Programming | |||
My VBA Function Won't Recalculate | Excel Programming | |||
function does not recalculate sum | Excel Worksheet Functions |