hi, how do i fill a range with the outputs of a function using a loop? thanks
J jf317820 Mar 6, 2006 #1 hi, how do i fill a range with the outputs of a function using a loop? thanks
B Barry-Jon Mar 6, 2006 #2 What exactly do you mean? Do you want to loop through the cells in a range filling each cell with a formulat / function or just filling each cell with the result of the formula/function? What formula / function?
What exactly do you mean? Do you want to loop through the cells in a range filling each cell with a formulat / function or just filling each cell with the result of the formula/function? What formula / function?
J jf317820 Mar 6, 2006 #3 i have a function that outputs some random number, so i just want to create a loop to fill the cells in my range with a bunch of these random numbers
i have a function that outputs some random number, so i just want to create a loop to fill the cells in my range with a bunch of these random numbers
P Patrick Smith [MSFT] Mar 9, 2006 #4 Use a For Each loop to loop through the range of cells, then assign the variable in the loop to be equal to the results of your function. thanks,
Use a For Each loop to loop through the range of cells, then assign the variable in the loop to be equal to the results of your function. thanks,
