macro to paste in a user selected range

[TimlmiT]

Gurus,

I am attempting to copy data from one spread sheet and paste it in another. The recorded macro works great. But, I don't want to place the data in range("E12"), I want to user to specify the placement. Does anyone know the code to do that?

Range("AI1:AM6").Select
Range("AL1").Activate
Application.CutCopyMode = False
Selection.Copy
Workbooks.Open Filename:= _
"\\Vmfiles\users\timlmit\My Documents\Excel test\master RFQ\MASTER QUOTE LIST.xlsx"
ActiveSheet.Paste
Range("E12").Select
End Sub

TIA,
Tim

[patel45]

Please Login or Register  to view this content.

[TimlmiT]

Awesome! Thanks Patel45. I saw you posted this similar answer somewhere else, but I couldn't figure it out for my specific application.
Thanks again!
Tim