How do I insert test into a merged cell or text box in word?

[Craig_Adam]

I have managed to insert test data and user inputed test data into an Excel spreadsheet to creat a report with no problem. The only dificulty im having is that certain parts of the user input data are long texts and need to be added to merged cells on the report. Is this possible?

[MikeS81]

Hi new2this,

the attached picture shows how you can merge cells. If you have merged cells, then you can write values to it, with selecting one of the cells in the merged range.

Hope it helps.

Mike

[Craig_Adam]

Thank you. I already have merged cell in my document and have tried to input a text string to the area but unfortunately the string just disappears. I will use the code you have shown me and see if I can input the data to the first cell in the area and then merge this area together. Once again thank you for your help.

[MikeS81]

Hi new2this,

if you have merged cells, for example A1-A10, then you can select each element from A1 to A10 to insert your text there. In my tests it worked great.

Mike

[Craig_Adam]

Hi Mike, I have attached an image of the code I am using, is there an easy way of modifying this code to achieve the result. I have multiple occasions of this VI so that i can input user data into various cells on various sheets. Help most appreciated. 

[MikeS81]

Hi new2this,

sorry for the confusion. If the cells are merged, then you have to write into the first of these merged cells. See the attached example.

Mike