As ALWAYS, post your macro for comments. I suspect that it is referring to
the original workbook. If you want to use for ANY workbook change the
reference to something like
activeworkbook.range("a1").copy

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gwtechie72" wrote in message
...
I am having problems running a Record macro. I use use the command to find
a
specific person. Copy the specfic data and paste it into a different
worksheet. Once the record macro is saved. I close out of Excel saving the
marco, and open an different file, once I run the macro I get a run time
error 91 and asks me to end or debug. I am not 100% familar with writing
the
macro. Can anyone help??