NO way to help unless you tell us exactly what the error message is and the
text of the line of code that is highlighted in the debugger.

On Wed, 23 Mar 2005 01:47:01 -0800, magpie
wrote:

All the macros I have in various workbooks are failing - usually part-way
through - with different error messages each time. When I check the debugger
and try to edit the text, there seems no reason why there should be a
problem. The macro has so far stopped on instructions to :
- open a workbook
- select a worksheet
- paste a column in a different place

Several times the macro has just stopped running without completing and
without showing an error message.

I cannot run a host of urgent daily reports without using the macros. Please
help!