Thread: simulate click into cell and get out?

Hi,

here is my problem:

I copy some cells with wrapped text into some other cells, but for some reason, the destinatino cells show with text in one line. However as I click into the cell, text displays correctly in the formula bar, and as I get out cell displays correctly as well, with the wrapped text...

Anybody out there faced a similar problem?

and trick around it?

thanks!

Nothing special. Wellknown phenomenon.

Probably for cell A10:

cells(10,1).value=cells(10,1).value