Is there any reason why you cannot copy the values from a single cell and paste the values into 2 merged cells? I have a macro running that resets my sheet to its original state but it won't fill the info into the merged cells. The merged cells have a data validation drop down menu so I don't want to have to split the cells up and align the text to centre across selection.