in my database I am copying a number of cells from one sheet into another
and using paste special/values. I then run a macro to insert a line which
moves the information down a row. However, one cell contains text with upto
200 characters and whenever the paste takes place the text never copies to
the cell on the new sheet even though cells on both sheets are formatted to
text. Can anyone help please?

DAT