View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rsankh[_2_] rsankh[_2_] is offline
external usenet poster
 
Posts: 1
Default result on a new sheet


In a micro ...
I have given sample in the sheet 1. I generate random numbers on a ne
sheet say sheet 2. Then I insert a new sheet(sheet3) and calculate mea
from the data on sheet 2.
When I run the macro next time , random numbers are generated on th
sheet 4 , and on the sheet 5 it calculates the mean from the rando
numbers on sheet 2.
How is it possible that everytime I run a macro , it calculates th
mean from the random nubers on the previous sheet ?
TIA
rsank

--
rsank
-----------------------------------------------------------------------
rsankh's Profile: http://www.msusenet.com/member.php?userid=187
View this thread: http://www.msusenet.com/t-187051260