katie
08-25-2008, 03:10 PM
I'm trying to write a macro to use the random sampling function I found on this website. I want to take the number of values in column P and then sample that number from column R (without replacement) and have the output go to column S.
When I run the code as is (see attached) I dont get an error but no results appear in column S.
When I try and include Input and Take into the equation for the input range and take arguments I get an error message.
Please help!
Thanks,
Katie
When I run the code as is (see attached) I dont get an error but no results appear in column S.
When I try and include Input and Take into the equation for the input range and take arguments I get an error message.
Please help!
Thanks,
Katie