Are you running this from a commandbutton on the worksheet?

If yes, there's a bug in xl97 (fixed in xl2k). Set the .takefocusonclick
property of that button to false.

If you're running this from a control from the controltoolbox toolbar that
doesn't have that property, just add a line like this at the top of your code:

activecell.activate



Ron Bishop wrote:

I have an application that was developed in Excel 2000 and
works fine on all users pcs that are running Excel 2000.
On one user who is still using Excel 97, the application
fails on a line of code that reads "sheet2.cells.clear"
with the message "Clear method of range object failed."

The strange thing is that the same procedure executes the
same code for sheet1 at an earilier point in the procedure
and does not produce the error.

Thanks

--

Dave Peterson