One way to force a User-Defined-Function to calc when a filter is updated is
to include a SUBTOTAL function call, but one that doesn't actually do
anything, along the lines of:

For numeric values:
=UserDefinedFunction(A1:A100) +IF(SUBTOTAL(9,A1:A100)0,0,0)

For string values:
=UserDefinedFunction(A1:A100) & IF(SUBTOTAL(9,A1:A100)0,"","")

HTH,
Bernie
MS Excel MVP

"internerdj " wrote in message
...
Nope thats not it. All of my calls from the spreadsheet are directly to
functions. Since the calls ignore the lines about other cells, what
can I do to force these functions to actually execute when a filter is
performed?

What is going on is that I need a chart that will give me a bar graph
showing the count of each unique equipment type in a column, and I need
it to update automatically to chart only those values that are shown by
the filters.


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