Unday,

This will prompt the user where to paste. The user can type in a range, or
select it with the mouse:

Sub test()
Dim paste_range As Range

'"type := 8" means that it only accepts a range as input
Set paste_range = Application.InputBox(prompt:="Where to paste data?",
Type:=8)
Worksheets("Sheet1").Range("A1:A5").Copy _
Destination:=paste_range
End Sub

hth,

Doug Glancy

"Unday" wrote in message
...
In Lotus 1-2-3 I was able to program into a macro to promp for data(i.e. a
range to copy data to). I haven't been able to do that in excel 97. I
know
there must be a way. Can anyone help me?

Regards,

Unday