Posted to microsoft.public.excel.programming

Suhao He

external usenet poster

Posts: 2

question on using average function in macro

Hi, all

I have a question on using average function in macro.

I have couple of cells, for example from cells(3.4) to cells(3,55) and
I want to get the averaged value of them. Is there a function I can
directly use in macro?

I found one object WorksheetFunction.Average(Range). How Can I convert
Cells(3,4)~Cells(3,55) to a range value?

Thanks,

Suhao

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
Average function question	Sum Limit and marking	Excel Worksheet Functions	4	July 8th 06 12:51 AM
Average function question	chapm4	Excel Worksheet Functions	4	January 11th 06 09:44 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row	Sam via OfficeKB.com	Excel Worksheet Functions	13	July 31st 05 03:59 PM
Average Question	LS Steakhouse[_2_]	Excel Programming	7	March 15th 05 09:41 AM
Variable sized average macro/function	danwtf2004	Excel Programming	2	January 29th 04 10:11 PM

All times are GMT +1. The time now is 09:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us