paste - ExcelBanter

Posted to microsoft.public.excel.programming

jobra

external usenet poster

Posts: 13

paste

Thank you very much. This was exactly wath I wanted to know.

"Aram Sargsyan" wrote:

Range("A1:L1").Select
Selection.Copy
Range("A3:L3").Select
ActiveSheet.Paste

works perfectly if you are copying range

for copiing whole line use

Rows("1:1").Select
Application.CutCopyMode = False
Selection.Copy
Rows("3:3").Select
ActiveSheet.Paste

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Paste and Paste Special No Longer Working - Excel 2003	SheriJ	Excel Discussion (Misc queries)	2	January 15th 09 09:23 PM
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.	stan-the-man	Excel Worksheet Functions	7	June 14th 06 08:10 PM
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
Macro to Paste to specific line, and continue to Paste each time on next row not over	tomkarakowski[_2_]	Excel Programming	1	May 28th 04 06:50 PM

All times are GMT +1. The time now is 10:16 PM.

Menu

About Us