Jessica1981
New Member
- Joined
- Aug 19, 2009
- Messages
- 13
Guys you could save my life! - that is ... if you can help me with this question 
Really appreciate it if you could, here it is..
Write a subroutine RndInt() that generate n random integers and output them one by one to consecutive cells in any empty column in the worksheet. Use an “Inputbox” to prompt the user to enter how many numbers to generate (i.e. the value of n). Each random integer should lie between 1 and 100. Value in the previous cell is added to the new integer before the new value is output (e.g. if value in the previous cell is 5 and the random current number is 4, the output value is 9). After the number generation process, calculate the average of those generated numbers. (Hint: Use Randbetween(), Average() functions in Excel and ‘For...Next’ construct.)
Really appreciate it if you could, here it is..Write a subroutine RndInt() that generate n random integers and output them one by one to consecutive cells in any empty column in the worksheet. Use an “Inputbox” to prompt the user to enter how many numbers to generate (i.e. the value of n). Each random integer should lie between 1 and 100. Value in the previous cell is added to the new integer before the new value is output (e.g. if value in the previous cell is 5 and the random current number is 4, the output value is 9). After the number generation process, calculate the average of those generated numbers. (Hint: Use Randbetween(), Average() functions in Excel and ‘For...Next’ construct.)
