copying multiple selections
 

Hello. Does anyone know how to do this? For exemple i need to copy
several rows. If i try to do this i get an error. Thanks.


--
adinic
------------------------------------------------------------------------
adinic's Profile: http://www.excelforum.com/member.php...o&userid=31529
View this thread: http://www.excelforum.com/showthread...hreadid=516123

copying multiple selections
 

Are you copying a range? or are you copying a row??
if you copy a range, and then try to copy it to a row then you will get
an error
ex:
copy range A1:G1
Paste to row B1
you will get an error that says it won't fit because they are not the
same size
also, if you are trying to copy merged cells you could get an error
message
so whjat kind of error are you getting??

copying multiple selections
 

Sub AA()
Dim rng As Range
Set rng = Range("1:3,5:5,7:10")
rng.Copy Destination:=Worksheets("Sheet2").Rows(1)
End Sub

works. But without more information, it is hard to tell what you want.

--
Regards,
Tom Ogilvy

"adinic" wrote in
message ...

Hello. Does anyone know how to do this? For exemple i need to copy
several rows. If i try to do this i get an error. Thanks.


--
adinic
------------------------------------------------------------------------
adinic's Profile:
http://www.excelforum.com/member.php...o&userid=31529
View this thread: http://www.excelforum.com/showthread...hreadid=516123