are you talking about you want to calculate that worksheet or you want to run
that function from VBA?
ben

"Floyd" wrote:

What is the syntax to force a function to calculate from another sheet?

Function Test()

End Function

Worksheets("Sheet1").Test.Calculate

This won't work, but I think I am getting close.

Thanks in advance.

Floyd