I have a VBA script in Excel that fills data from one spreadsheet to
another. In the output file some of the cells are having the
formatting .WrapText = True. Now I have the strange situation that
some cells display half a line or an entire line of white spaces at
the end, even though in the text no blank or special characters are
present.

I'd like to get rid of the white space or at least understand why this
is happening. I have looked at the size of the cells, the number of
characters but I have not yet found the trigger for the phenomenon.

I have been searching quite some time now and everybody seems to have
the same issue. Unfortunately I have not yet found the solution.
That's why I ask again.

Any ideas are welcome
mat