View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Floyd[_2_] Floyd[_2_] is offline
external usenet poster
 
Posts: 35
Default Forcing a function to calculate

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