Randomize a Column & Identify a Word

[rwmill9716]

I have a set of letters in Column A. That Column has been randomized in Column B where the word 'Ric' from Cell C1 is found. I need a macro that will randomize Column A 1000 times and count how many times 'Ric' is spelled out.

 

[bebo021999]

Try to attach a sample workbook via gg drive (like I did), with your actual data.