You already have good answers from Dave & Norman, so just this-

I have merged cells A1..C1 and named it rngTest.

I expect you only named A1. Had you named A1:C1 your code would work without
modification.

If the cells are already merged you'd need to enter the address fully in the
RefersTo box in the names dialog Ctrl-F3.

Regards,
Peter T
-
"ArthurJ" wrote in message
...
I have merged cells A1..C1 and named it rngTest.
I enter data into rngTest.

Range("rngTest").ClearContents
'Generates Error 1004 Cannot change part of a merged cell.

Range("rngTest").Select 'or Activate
Selection.ClearContents
'Runs successfully.

This sure seems bizarre. Does your machine perform like mine? Any
suggested
workarounds? I would prefer NOT to select these cells programmatically.

Art