On 29 Mrz., 14:58, wrote:
On 29 Mrz., 12:33, "NickHK" wrote:



If you paste all the text one cell, you will lose the formatting.
If you paste over multiple cells, formatting will remain.
Choose which.

There are ways to format the text within a cell (using .Characters), but you
will have to check each char in Word for bold, colour etc, then apply that
to the character in the cell.

NickHK

wrote in message

roups.com...

hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?

okay, this is very complex. could you tell me, how I should do this? I
do not know how to check each character and how I paste this into the
cell.

and very important is the numbering and bullets. how can I check this?