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