errot in macro

G

Guest

I am trying to run a macro that opens up several other spreadsheets and
copies and pastes selected data into the spreadsheet where the macro resides.
Sometimes this works. Sometimes I get the message 'Microsoft excel has
encountered an error and has to shut down' and it then shuts down Excel.
Whenever I step through the macro, I never get the error.

What is going on here?

TIA
Sanford
 
G

Guest

The only time that this has happened to me when doing simple copy/paste
operations using a macro is if I copy and then paste special as values.
Other than that without lots more detail its hard to tell whats going wrong.
 

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

Close Excel with a Macro 2
macros 3
Select drop down menu option using libre-calc macro 0
Problem with a complex Macro 2
Excell 2000 macro will not open file! 1
Copying parts of a sheet with macro 7
Macro to copy & paste data 3
Run Macro If Cell have "x" value 0

Top