Hi,

Sorry for the delay, this obviously would have helped.
When stepping through the application the error appears
when the following line of code is executed:

ThisWorkbook.sheets(SheetName).Cells(Row, Col) = value

John.

-----Original Message-----
When you get the error, what is the line of code that is
highlighted?

You should begin by looking at the line.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Hi,

I coded a VBA macro in an Excel 97 workbook that imports
data from several diferent excel 97 workbooks into the
one
master book (master book contains the macro).

We are now in the process of migrating to Office XP.
When
the macro is run in XP, I recieve the following error:

"Runtime Error 1004 -- Application Defined or Object
Defined Error"

The macro ran error free for several months in 97, so I
am
confident that this error is due to the change in
version.

Any suggestions or ideas on what could be causing this
error?

Thanks.

John.


.