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