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