I got the error message 'runtime error '1004' 'We can't do that to a merged cell.' when I was using the following code:
![We Can We Can](/uploads/1/2/5/0/125015867/864471709.png)
I am creating an Excel workbook where users select info on one worksheet and it is copied to a second sheet and put into a print friendly format. This particular piece of info goes from 1 cell on the original sheet to a merged 3-cell title on the output sheet.
I'm learning as I go, so I don't know what to do here.
Re: Unable to sort in Excel because of merged cells I need a way to sort a spreadsheet in Excel 2010 and keep the title and column headings at the top of the page. Right now when I unmerge the cells, this information is mixing in with the data when I sort.
DeanOC5,56366 gold badges3232 silver badges4848 bronze badges
Paul OwensPaul Owens
1 Answer
I'm not exactly sure how to do this the way you have, but you could probably change this code:
to this code:
Essentially putting the value to be copied into the print friendly one.
![Can Can](/uploads/1/2/5/0/125015867/482032904.png)
Shauno_88Shauno_88
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.