| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Recording find Maros
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?? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Recording find Maros
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find "Stop Recording toolbar" of macros? | Excel Discussion (Misc queries) | |||
| Can't find cell ref. when recording a macro in excel | Excel Discussion (Misc queries) | |||
| How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
| Recording changes | Excel Discussion (Misc queries) | |||
| recording macros | New Users to Excel | |||
Hybrid Mode
