Forum Discussion
Chrissie_SBI
Oct 28, 2021Copper Contributor
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
1 Reply
Could you attach a copy of the workbook that demonstrates the problem, without sensitive data?