Try this

Sheets("mobilisation").Range("h2:n8").MergeArea.Un merge


"Risky Dave" wrote in message
...
Barb,

thanks for the reply. this now throws up:

Run-time error 1004:

Application-defined or object-defined error


As you have probably guessed, I'm no programmer so I don't really
understand
what this is trying to tell me.

Dave

"Barb Reinhardt" wrote:

Try

Sheets("mobilisation").Range("h2:n8").MergeArea.Cl ear

HTH,
Barb Reinhardt

"Risky Dave" wrote:

Hi,

I have a range of cells that I need to clear before doing other stuff
with
them. These cells are formatted in a particular way and some of them
are
merged. I am trying to use:

Sheets("mobilisation").Range("h2:n8").Clear

but this is returning an error saying that Excel "cannnot change part
of a
merged cell"

As I can both Clear and Delete the content of these cells manually, I
assume
that I haven't got the syntax correct to do it in VBA?

Any help would be appreciated.

TIA

Dave