how to average a varying amount ou numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: cuewoz <cuewoz.2ce4sg_1155324915.2855@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 11 Aug 2006 15:33:52 -0400

I want to include some code in a module to average a range of numbers,
the problem is you dont know before hand how many numbers you will
have.
When someone runs the spreadsheet they enter a number which will be the
amount of figures to be averaged out, but I don't know how to use the
active.formula with a Range(Cells(3, 4), Cells(11, 5)).Select
type of command.
Can anyone help?
I know there isn't much to go on but please ask me what else you might
need to know.

Thanks

Warren

--
cuewoz
------------------------------------------------------------------------
cuewoz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32161
View this thread: http://www.excelforum.com/showthread.php?threadid=570900

.

Prev by Date: Re: Multi-sheet FIND capability
Next by Date: Re: Save file in a new folder, but create folder only if folder doesn't already exist?
Previous by thread: Re: Multi-sheet FIND capability
Next by thread: Re: how to average a varying amount ou numbers
Index(es):
- Date
- Thread

Relevant Pages

creating a ftp account
... profile of this user to log in, ... I dont want to delete some ... files and change my current directory with "cd" command. ... NETMBX ...
(comp.os.vms)
Re: help on triggering macro if cells change
... Unfortunatly they dont seem to work for cells that change but by way of ... cuewoz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32161 ...
(microsoft.public.excel.programming)
Re: Forms property using varables
... each command button opens the same form "form2" but displaying different ... i dont want to hard code P2602A, instead i want ti use a varable. ... when the command button is pressed on form1 it sets EquipmentTagString as ... Controls collection. ...
(microsoft.public.access.formscoding)
Re: ex2k Exchange 2000 - mailbox full message not being sent
... Leif Pedersen [MVP] wrote: ... It is not a profile issue. ... but at the mailbox store properties "Database, ... i dont have any message around to see who they came from, ...
(microsoft.public.exchange.setup)
Re: php-mysql
... >> login as root and give the following command ... > you could use apache2 but then I dont know where the config files are ... > I dont know which distribution you use, but in Debian Etch the files are ... server will only work on the server console till you tweek ...
(Debian-User)