how to unlock an union of cells?

[Brocktanor]

Hey there, I'am on an internship since a week and I have to build a template on VBA. I'ts the first time I code VBA and have still some issues. I search a lot of answers to questions I ask myself on the internet and this forum but I haven't found anything about unlocking a union of cells

I have tried this:

Please Login or Register  to view this content.

But I get a 438 error (Object doesn't support this property or method)

Can anyone help me out?

[ragulduy]

You can't have

Please Login or Register  to view this content.

because when you set the union to a range variable it takes on the sheet it applies to at that stage. Therefore you need:

Please Login or Register  to view this content.

[Brocktanor]

Thanks! Seems like I have some problems too due to merged cells (just read merged cells are evil in vba... )

[ragulduy]

Depends on how you want to deal with when you have merged cells but you cannot use vba to set the locked property of only one cell of a group of merged cells. This approach would adjust the range you select to include merged areas:

Please Login or Register  to view this content.

[Brocktanor]

Thanks a lot! Works perfectly and now I get how to work with merged cells!

[ragulduy]

No problem, as you may have found when doing your reading, the best method for dealing with merged cells and vba is don't use merged cells...