LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trim varying decimals from column of numbers AuthorizedUserPF Excel Worksheet Functions 9 March 30th 10 04:34 PM
Calculate Amount with Varying Percentages per Thousands Amaren Excel Discussion (Misc queries) 2 June 29th 09 04:55 AM
transposing vertical data to horizontal with varying amount of data Ghosty Excel Discussion (Misc queries) 5 August 1st 06 05:20 AM
How do I retain the format of varying numbers in Excel? xardoz Excel Discussion (Misc queries) 6 June 20th 06 05:16 PM
How do I see the amount in words (I will enter amount in numbers) Ram Excel Programming 1 April 12th 06 08:55 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"