Pause Macro to enter data in cell
Use Application.Inputbox with a Type:=8. This gives you a cell to use
thereafter.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"rleonard" wrote in message
...
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
|