copy rows and paste in another workbook

=?Utf-8?B?c3RldmVu?=

Guest

Posts: n/a

15th Feb 2007

Hello people,

Id like to construct a macro that copies all rows from the workshett I am
working in (copy the whole lenght of the row just as leftclicking the 1st row
number and holding and draging down until the last row with data is
selected), and then copying it to workbook2, sheet2 row2 , just as
rightclicking and chosing insert copied cells would. any suggestions?

Thank you in advance.

« Customize the right-click menu | Renaming data fields used in Row Area »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy & Paste from One Workbook to a Macroed Template Workbook	VickiMc	Microsoft Excel Programming	1	21st Sep 2009 09:52 AM
Copy Rows from master workbook & paste in other workbooks	farid2001	Microsoft Excel Programming	5	2nd Oct 2008 01:25 PM
macro to copy rows and paste-special to another workbook	Nitin	Microsoft Excel Programming	0	15th May 2008 07:40 PM
Selecting data from 1 workbook to copy and paste to a 2nd workbook	=?Utf-8?B?SmFja1NwYW0=?=	Microsoft Excel Programming	2	20th Jul 2005 02:33 AM
Copy a range of cells in an unopened workbook and paste it to the current workbook	topstar	Microsoft Excel Programming	3	24th Jun 2004 12:50 PM