Hi guys,
I have encountered an issue with keeping the text inside the merged cells. This is my code for merging cells: Range(Cells(xx + 5, xyz), Cells(xx + 30, xyz + 2)).Merge.
The cell references (xx and xyz) are variable in the x and y direction. After the next xyz, the text I entered disappears.
do you have any solution for me ?
I have encountered an issue with keeping the text inside the merged cells. This is my code for merging cells: Range(Cells(xx + 5, xyz), Cells(xx + 30, xyz + 2)).Merge.
The cell references (xx and xyz) are variable in the x and y direction. After the next xyz, the text I entered disappears.
do you have any solution for me ?