Clearcontents works very well in xl97, so I think you have to look for
another cause.

If you are running this from a commandbutton, possibly you are running into
the focus issue associated with xl97 and activex controls from the control
toolbox toolbar. In that case, try changin the takefocusonclick property of
the commandbutton to false.

--
Regards,
Tom Ogilvy


"Peter" wrote:

I have a spreadsheet written in 2003 with the following code

destcell.clearcontents

Where destcell is a valid range (consisting of a single cell).

This fails when running under excel 97.

I've tried

destcell.clear

but this fails as well.

Anybody recognise this behaviour?

Anybody know where I can find useful resources on what has changed?