View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Wold Lee Wold is offline
external usenet poster
 
Posts: 1
Default Randomize the order of the contents of an array

I have a range of cells 5 * 5 (A1:E5) which have string contents in them at
present. I want to run a macro that randomly sorts the existing contents
into different cells - it has to be the order of the existing content that
is randomly re-ordered not the content itself. Think of it similar to a
bingo card with the contents being the text strings one, two,...., twenty
five - where I want to produce random outputs for printing. How would I do
this in VBA.

Cheers.