| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste
I wish to copy a line and paste it into anotherline
Sub macro1() Range("A2:L2").Select ActiveSheet.Copy Range("A23:L23").Select ActiveSheet.Paste end sub This doesn't work Can anyone help me on this Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste
"Aram Sargsyan" wrote in message ... Range("A1:L1").Select Selection.Copy Range("A3:L3").Select ActiveSheet.Paste No selecting Range("A1:L1").Copy Range("A3") for copiing whole line use Rows("1:1").Select Application.CutCopyMode = False Selection.Copy Rows("3:3").Select ActiveSheet.Paste Ditto range("1:1").Copy Range("A3") |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste
jobra Wrote: I wish to copy a line and paste it into anotherline Sub macro1() Range("A2:L2").Select ActiveSheet.Copy Range("A23:L23").Select ActiveSheet.Paste end sub This doesn't work Can anyone help me on this Thanks Hi jobra Try this Range("A2:L2").Select Selection.Copy Range("A23").Select ActiveSheet.Paste Range("A1").Select -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=397699 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming | |||
Hybrid Mode
