Application.Volatile messing up other function
 

Thanks for the reply. But it still doesn't work. I tried removing al
calls to the other sheet out of my functions and passing the name o
the sheet as an argument but it still didn't recalculate automaticall
(maybe because the arguments never change). I am really stumped o
this one. But can anyone tell me why the Application.Volatile i
blocking the other functions from running

--
Message posted from http://www.ExcelForum.com

Application.Volatile messing up other function
 

I don't think passing the name of the sheet will Excel to recognize the
dependency. You didn't give your code, but how would Excel understand that
something between quotes means a whole sheet? You might as well want to
print that text.
You really have to pass the ranges.
As for your second question: No. But that is just because I find it
difficult to understand what your functions do.

I know it's a lot of work and feel sorry for you, but I strongly suggest you
follow the recommendations to pass all arguments, without "tricks" like
passing worksheetnames.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"itchyII " wrote in message
...
Thanks for the reply. But it still doesn't work. I tried removing all
calls to the other sheet out of my functions and passing the name of
the sheet as an argument but it still didn't recalculate automatically
(maybe because the arguments never change). I am really stumped on
this one. But can anyone tell me why the Application.Volatile is
blocking the other functions from running?


---
Message posted from http://www.ExcelForum.com/