Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My VBA Function Won't Recalculate
Hi, I have created a function in VBA to use in my excel worksheets. It is an "if" function referring to a number on a different sheet i.e. =if(sheet2!H15=1,do this,do that). It works fine except that it won't recalculate when I change the number on the other sheet. I have to press shift + F9 in order for it to give me the correct value. I have tried application.volatile but it doesn;t have any effect. Any suggestions? Thanks Adam -- soteman2005 ------------------------------------------------------------------------ soteman2005's Profile: http://www.excelforum.com/member.php...o&userid=29078 View this thread: http://www.excelforum.com/showthread...hreadid=489778 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculate in VBA | Excel Discussion (Misc queries) | |||
Refresh/Recalculate a Custom Function | Excel Worksheet Functions | |||
function does not recalculate sum | Excel Worksheet Functions | |||
will not recalculate | Excel Worksheet Functions | |||
Recalculate Custom Function | Excel Programming |