I have a column with a bunch of text in column A in sheet "Rate".

I want my macro to randomly select one of the text values and use that as the value for a variable.

For example here is pseudo code:

DIM y
y = find value of random cell in column A in sheet Rate.

So the column could have a list of fruit, and at the end of running this part of the code the value of y could be "Apples" by random selection

Thanks