Still I have not finished my task.
I would like to pick n different cells at random from column A and make
up another column from the selected n cells.
My knowledge of excel and VB is another VB (very basic). This is how I
am thinking of accomplishing my task. Create a Macro in VB to do the
Pick a cell at random, copy the content to an array and
delete that raw and compact the column. Then
for 2 to n
pick another cell at random add it to the array and
delete that raw and compact the column.
Copy the array to another empty column.
I would very much appreciate if any one can help me to produce the
--- Begin Forwarded Message ---
Date: Mon, 12 Mar 2001 12:07:05 +0000
From: Nadarajah Thirugnanasothy <[log in to unmask]>
Subject: To pick n cells at random from a column
Sender: [log in to unmask]
To: [log in to unmask]
Reply-To: Nadarajah Thirugnanasothy <[log in to unmask]>
Message-ID: <[log in to unmask]>
Could you please tell me how can I pick n cells at random from a column
--- End Forwarded Message ---