Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trim varying decimals from column of numbers | Excel Worksheet Functions | |||
Calculate Amount with Varying Percentages per Thousands | Excel Discussion (Misc queries) | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
How do I retain the format of varying numbers in Excel? | Excel Discussion (Misc queries) | |||
How do I see the amount in words (I will enter amount in numbers) | Excel Programming |