Hi,

Can someone help me.
I created excel macros in Excel 2000, however when the macro is opened with
Excel 97 some errors occur. These are some of them:

1.The following command gives RunTime error '1004'
Unable to set the ColorIndex of property of the Interior Class
Sheet13.Cells(StartRow + Row, StartColumn + Column).Interior.ColorIndex = 0

Is there any equivalant code in Excel 97 for the above command?
Why the macro caused error in 97, but not in 2000? Was Interior class not
part of worksheet member?

2. The application terminates automatically when a part of macro is executed
and the following message is displayed on the error dialog box:
"<process has already exit has generated errors and will be closed by
Windows. You will need to restart the program. An error log is being created."

What is the cause of this error? Where can I find the error log?
I tried to put somebreak points to trace the problem, however the error did
not come out during the debug mode. It only came during run time. Why Excel
2000 doesn't have the problem?

Your help is appreciated.

Regards,
Chris