Hi Sasa,

it is always better to use ".Select

Contrawise, I would suggest that selections are rarely necessary or
desirable and are usually inefficient.


---
Regards,
Norman



"Sasa Stankovic" wrote in message
...
it is always better to use ".Select".... this way you are sure Excel knows
what to select and later than what to do with selection!
much safer and it doesn't slows down your macro if you are looking for
optimization....
"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