Excel and Merged Cells

New Contributor

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

1 Reply


Could you attach a copy of the workbook that demonstrates the problem, without sensitive data?