View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cuewoz[_3_] cuewoz[_3_] is offline
external usenet poster
 
Posts: 1
Default how to average a varying amount ou numbers


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 wil
have.
When someone runs the spreadsheet they enter a number which will be th
amount of figures to be averaged out, but I don't know how to use th
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 migh
need to know.


Thanks

Warre

--
cuewo
-----------------------------------------------------------------------
cuewoz's Profile: http://www.excelforum.com/member.php...fo&userid=3216
View this thread: http://www.excelforum.com/showthread.php?threadid=57090