Converting nodelist to string VBA

[TildesleyH]

Hi Excel Forum,

I'm hoping someone can tell me how to convert a nodelist into a string to be inputted into a single cell r(,6). I'm attempting to obtain an example sentence for each word in Column A. My code with the desired selector is as follows:

Please Login or Register  to view this content.

Column A contains values such as:
谷
動詞
被害者

Many Thanks

[TildesleyH]

I was able to accomplish this with the following:

Please Login or Register  to view this content.