Hi everyone, this is my first post. Here I am working with "Bootstrap" method, which is used to non-parametric confidence interval. To do this I need to draw samples from a population.
To do this I used "sample" function, created by Patrick Matthews. However I could not post the exact address, as I need to post at least five threads (ridiculous isnt it?) to do that.
I used that by following way:
Sample(Sheets("temp3").Range("A1:A500"), no, True, False), which is working fine.
But the problem is, my last row, here, A500 is not fixed, i.e length of column is determined by a variable say "no". Therefore I tried following code:
Sample(Sheets("temp3").Range(cells(1,1), cells(no,1))
But unfortunate it is not working.
Can anyone tell me how to solve this problem?
Your help will be highly appreciated.
Regards,