MergeCells & Run-time error '1004' - Unable to set the Hidden property of the Range class

Hello,

I recently added the below merge function to an excel sheet that already had code. Everything in the sheet works fine until I run the Merge macro. I have several formulas throughout the sheet, so it needs to be password protected. Once I run the merge function, the sheet loses its ability to automatically hide and unhide rows. I have tried moving ActiveSheet.Protect to the end of Worksheet_Change and have also tried moving the entire Merge function to the very end of the code. Does anyone have a fix for this? Thanks for your time!

Please Login or Register  to view this content.

Thank you! That worked! I agree that merged cells can cause a lot of problems. This form is used quite often at my workplace over multiple employees. Luckily, we have an ERP system that will allow us to have access to previous versions of the files if the merged cells ever work against us. Again, thank you for your help!