Hi
within you macro use application.inputbox
and set the type:=8 to get a range
use this range as target cell

--
Regards
Frank Kabel
Frankfurt, Germany


rleonard wrote:
I have macro that goes to a cell then copies data; then using goto i
go to a general area;

at this point i need to manually locate where i want to paste data,
after which I want macro to resume.

Is their a way to pause macro?

thanks Bob Leonard