Thanks guys I ended up not needing the Application.Volatile. I
replaced the activecell with adding an additional variable that would
look at the same column as the weeks. That seems to have fixed it.
Thanks again for the quick responses and help.
Jacob
On Aug 20, 12:52 pm, Sandeep Kumar Maurya
Hi
Please add this line to your function. Adding on the first line will be good.
Application.Volatile
This will cause recalculation of the function when any value change in
the sheet. (So directly affect the speed if you use function on many
cell)
Thanks & Regards
Sandeep
On Fri, Aug 20, 2010 a
