can use this need to check for value etc in cell befor copy been trying to do
this with copy & paste in a macro. lot more code than here just need to
validate.
"Don Guillett" wrote:
It does not have to pause unless you were asking for the value to lookup.
use FIND to find it and copy to the new address. Example
Sub findandcopy()
Columns(1).Find("x").Copy Range("c12")
End Sub
--
Don Guillett
SalesAid Software
"CCB AA" <CCB wrote in message
...
Writing a marco and I need a "pause" so I can copy info from another
wookbook
and insert it in the current wookbook. How do I make a macro pause,
lookup,
copy, insert and then move on?