Posted to microsoft.public.excel.programming

Peter Chatterton[_2_] Peter Chatterton[_2_] is offline

external usenet poster

Posts: 17

Can't copy ActiveSheet to clipboard

Shouldn't this code create a new worksheet from the active one?

It does create a new sheet,
but just copies the current clipboard to it.

ActiveSheet.Select
ActiveWorkbook.Sheets.Add After:=Worksheets(1)
ActiveWorkbook.Worksheets(2).Paste

Thanks,
Peter

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
Can't copy without clipboard open	Bill Williams	Excel Discussion (Misc queries)	0	January 4th 05 04:41 PM
VBA execution stops at ActiveSheet.Copy -- but only sometimes!	Ole M Halck	Excel Programming	3	August 19th 04 04:47 PM
ActiveSheet.Copy	Bill Oertell[_2_]	Excel Programming	1	December 31st 03 03:46 AM
How to copy text from a TextBox in a ActiveSheet to a variable	Tom Ogilvy	Excel Programming	2	August 19th 03 06:35 PM
How to copy text from a TextBox in a ActiveSheet to a variable	pat	Excel Programming	0	August 19th 03 05:06 PM

All times are GMT +1. The time now is 07:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us