Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
the formula for random selecting	Inquiring mind	Excel Discussion (Misc queries)	2	March 19th 09 02:33 PM
Selecting Random Data	myssieh	Excel Worksheet Functions	5	February 13th 08 05:09 PM
Selecting Random Data	Willie	Excel Worksheet Functions	2	August 18th 05 06:26 PM
selecting random records	terry freedman	Excel Programming	2	April 2nd 04 11:07 AM
selecting unique and random values	kvp0431	Excel Programming	0	October 16th 03 10:00 PM

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

About Us

"It's about Microsoft Excel"