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?

Is the destcell a locked cell on a protected worksheet?

Is the destcell part of a merged cell?
destcell.value = ""
may work in any version



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?

--

Dave Peterson

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?