Custom counting functions not updating?

I wrote a few custom functions to count various items on my main sheet. These two functions are called on a different sheet where all of the calculations and statistics are reported. To get them to update, I have to highlight the forumla where I call the functions and press enter (just like re-entering the formula, but not re-typing it). Does anyone know why they aren't updating? Is there any way to force them to update without doing something like "Private Sub Worksheet_Change(ByVal Target As Excel.Range)...?" If I do that, it will slow down the entire worksheet. Any ideas? Thanks!

Insert this in your User Defined Function

Please Login or Register  to view this content.

Boon

That worked perfectly, thank you!