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