Using Excel 2003..

I created a simple macro command button... Autofilter - Custom - equals "Open" OR equals "Active

When I autofilter with the same criteria, things work fine. If I use the autofilter macro, it causes #VALUE! errors in several cells.

I have a UDF...

Function isformula(rng As Range

Application.Volatile (True
isformula = rng.HasFormul

End Functio

An example of a formula causing the error: =IF(K55="","",IF(AND(isformula(K55),K55=TODAY())," ",TODAY())

It seems related to recalculate and the UDF... b/c once I press F9, the errors are gone. But I can't figure out how to force recalculation within the macro. (I don't want users to have to press F9) I've tried application.calculate, and other suggestions found in this news group, but nothing's worked so far

Any suggestions?

TIA
Jill.