Error: Cannot change the part of merged cell - When trying to lock cells in range

Hi,

I have some ranges defined in the worksheet.

I want to make ready only certain cells in the sheet.

Below is code which I am using, However it is locking all the cells in the range. I want to lock the cells upto some specific row in the range.
like till first 20 rows in the range.

Please Login or Register  to view this content.

I get an error message saying "Unable to set locked property of the Range Class. When I come out of debug mode it says "Cannot change the part of merged cell " , Actually the column cell is a merge of two cells...and it is bcoz of this it throwing the above error.

Can somebody tell how to set the locked property of some cells in the range where the column cell is merged cell.

Thanks

I can have the merged cells (in my case two cells merged form one column)to be locked together or unlocked together.

I just want to lock only some 20 rows in the range where the actually range covers more than 20 rows

the range refers to something like 'Information'!$D$10:$E$100

Where 'Information' is the sheet name and rows start from 10 to 100 and columns are both D & E merged together as one column.

Now, I just want to lock rows from 10 to 30 where merged column together can be locked.

Hi Ross,

Yes, I did try the same code you modified. However now it has locked the whole sheet.

I am wondering , if i have missed something.

Please Login or Register  to view this content.

Thanks