multiple selection - vba

[lezawang]

Hi
I want to copy the selected cells to another part of the sheet by selecting the destination range as well. right now I can only use the destination as a cell/range as it is shown in the code below. I wonder if the destination range can be selected as well (by using the mouse). I tried to select both using CTRL key but then excel gave "multiple selection" error message. Than you.

Sub myselction()
[INDENT]Selection.Copy Destination:=Cells(10, 10)[/INDENT]
End Sub

 

[Fluff]

If you want to select both ranges how about

Sub MyCopy()
   Selection.Areas(1).Copy Selection.Areas(2)
End Sub