ExcelBanter - selecting random cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - selecting random cells (https://www.excelbanter.com/excel-programming/350604-selecting-random-cells.html)

willie

selecting random cells

Hi

I have a sheet with data in cells a2:a11. I want to randomly select any 3
cells and paste the data on another sheet. How can I do this in VBA?

All times are GMT +1. The time now is 06:16 PM.