Forum Discussion

Chrissie_SBI's avatar
Chrissie_SBI
Copper Contributor
Oct 28, 2021

Excel and Merged Cells

Hello! I hope someone will be able to help. Also Hope I'm putting this on the right discussion board. I have been using the same spreadsheet in Excel forever and now I keep getting the Error Code:

 

Microsoft Visual Basic

Run-time error '1004': 

To do this, all the merged cells need to be the same size.

 

I have used this spreadsheet in the past with the marcos to sort the date, but suddenly now it will not work. I have trusted the VBA, didn't change anything with the sheet, made sure my computer was up to date, multiple people at my job have tried it.... 

 

Any help would be very much appreciated. Thank You

Resources