Posted to microsoft.public.excel.programming

TGalin

external usenet poster

Posts: 81

Random Copy Paste

I pasted the macro I have below. I want to add to it so that it will
randomly select 20 of the cells from the range E2:E159 to copy and paste
those contents starting in cell B2. Is this possible?

Random Copy Paste()
Range("E2:E159").Select
Selection.Copy
Range("B2").Select
ActiveSheet.Paste
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Select Random rows and paste it in a different sheet.	Heera	Excel Programming	0	January 28th 09 07:26 PM
Automating copy/paste/paste special when row references change	Carl LaFong	Excel Programming	4	October 8th 07 06:10 AM
Excel cut/Paste Problem: Year changes after data is copy and paste	Asif	Excel Discussion (Misc queries)	2	December 9th 05 05:16 PM
Copy and Paste macro needs to paste to a changing cell reference	loulou	Excel Programming	0	February 24th 05 10:29 AM
Random Copy and Paste	Jason	Excel Programming	2	September 10th 04 09:27 AM

All times are GMT +1. The time now is 08:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us