Issue in copying the excel sheet

As per the excel forum it seems we can’t copy excel merged row sheets,
please check the below link for alternative solution
"we can't do that to a merged cell" - how to turn off this warning? [SOLVED]