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