Recording find Maros

G

gwtechie72

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??
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Drop down list control value in vba 2
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA Coding Help for Beginner 0
Global Template Network and saving auto texts & macros 2
Want to have macro execute automatically when doc created 3
Copy previous record into form field 0

Top