@Polanskiman - thanks again for reporting these two issues and providing the sample workbook. I wanted to let you know my findings and possible actions.
1- Missing data in the generated XL2BB code.
The new line used in the cell values causing this problem.
This is a bug and it will be fixed in the next update.
2- Data validation in merged cells.
This is actually kind of an Excel inconsistency.
When we have a cell with data validation and merge it with adjacent cell later, merged range doesn't have the same data validation unless two cells are forced to have the same validation. Therefore VBA has nothing to do but fail if it is asked to return any information about the data validation on that range.
To see how Excel tries to handle this issue, please try this: Select G6 (merged with H6 that has the Data Validation) and click on Data Validation on the ribbon. See how Excel tries to solve it with user interaction before executing the actual requested command.
Side note: Confirming the following will end with copying the same data validation to G6. And if cells are un-merged later then there will be two adjacent cells with the same data validation.
XL2BB can't ask something like this as it is not supposed to alter anything in the workbook. Therefore, I will force XL2BB to stop execution and tell user about the merged cells which don't have the same validation. It will be surely better interaction than 1004 error.
Necessary change will be applied in the next update.
Some suggestions for the user side to make it work before the update (separate solutions that will avoid this problem):
1- Merge first, then create the data validation.
2- If merge should be done later, then select the merged range and click on Data Validation to have Excel to extend the Data Validation on the cells in the merged area. (above example).
3- Don't use cell merge in Excel (at least for nothing other than labeling) - Of course funny suggestion but personally I wish Excel never provided such thing. It is against whole tabular data logic.
Thanks again!