Try "Worksheets("SheetName").Calculate.

HTH
Ed

"Jill" wrote in message
...
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.HasFormula

End Function

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.