B
Brotherwarren
Hi,
I have a problem I can't solve.
I have a list of comments written in a range in a shared workbook.
Individual users open the book and edit the comments, before saving
and closing.
The problem I have is that some users copy their comments from word.
Often they have used carriage returns to start a new line. This
causes half of the comment to be pasted into the correct cell, and the
rest to be pasted into the cell(s) below.
Is there a way to prevent this from happening?
Many thanks for any advice.
Tony
I have a problem I can't solve.
I have a list of comments written in a range in a shared workbook.
Individual users open the book and edit the comments, before saving
and closing.
The problem I have is that some users copy their comments from word.
Often they have used carriage returns to start a new line. This
causes half of the comment to be pasted into the correct cell, and the
rest to be pasted into the cell(s) below.
Is there a way to prevent this from happening?
Many thanks for any advice.
Tony