Macro to export to excel, how to paste multiple rows of text into one cell?
Hi all,
I can't seem to find a way to solve the following: I want to extract a certain text from a textbox using CopyTextToClipboard in a macro function, and then paste it to a predetermined cell in an excel file.
Instead of placing this text into the cell, it pastes all the lines of the text to seperate rows (overwriting all the text in the rows under the predetermined cell...).
Here is my macro code (so far), with the described part in bold text: