Posted to microsoft.public.excel.programming

Floyd[_2_] Floyd[_2_] is offline

external usenet poster

Posts: 35

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cant calculate sum function	Neeraj Paul	Excel Discussion (Misc queries)	9	May 31st 09 06:09 PM
Calculate function Xx+1=rX(1-X). How?	Kanon	Excel Discussion (Misc queries)	2	March 19th 07 08:01 PM
function doesn't calculate	[email protected]	Excel Worksheet Functions	3	December 18th 06 04:26 AM
Function Won't Calculate -- Sometimes	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	April 13th 05 04:38 PM
How to calculate PMT function	Daniel	Excel Worksheet Functions	1	November 18th 04 08:42 PM

All times are GMT +1. The time now is 03:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us