View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lrjanzen13 lrjanzen13 is offline
external usenet poster
 
Posts: 6
Default Lock a named range

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