View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How do I randomly select cells regardless of cell content?

If you mean randomly find the value of a cell,
=INDEX(1:65536,INT(RAND()*65536),INT(RAND()*256))
Every time a calculation is performed, this will randomly pick a different
cell in the spreadsheet.

If you want an actual selection, you'll have to use VBA. If we knew more
about the goal/purpose, might be able to provide additional help.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gmadden2" wrote:

I'm attempting to unconditonally and randomly select cells in a spreadsheet