Posted to microsoft.public.excel.programming

external usenet poster

Posts: 23

worksheet function?

Mm..how to write average worksheet function in VBA? worksheetfunction.average?

How do I reference to the range of cells in another worksheet? Is it like
this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))?

Thanks!

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
Worksheet Function	Brennan	Excel Discussion (Misc queries)	1	March 17th 08 04:18 PM
Worksheet Function	grobertson	Excel Worksheet Functions	1	June 8th 07 05:55 PM
Is there a worksheet function that will...	Adam Kroger	Excel Worksheet Functions	1	November 20th 05 07:41 PM
Reference the worksheet from a multiple worksheet range function (	DBickel	Excel Worksheet Functions	1	May 28th 05 03:49 AM
Can the offset worksheet function reference another worksheet	AlistairJ	Excel Worksheet Functions	2	May 9th 05 06:18 PM

All times are GMT +1. The time now is 01:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us