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