Merged cells are a pita. If you can change the name's definition have it
refer to all cells in the merge. If not, create a new name to do that.

--
Jim
"lrjanzen13" wrote in message
...
|I have a named range (='Site Limiting Factors'!$J$10) that defines a named
| range for several merged cells. When I call MYRange.Lock I get an error
| "Cannot change part of a merged cell." How do you lock and protect a
Merged
| cell?
| --
| Thanks
| Lonnie