cell format changes

[ricksimm]

I have a cell formatted as General and shrink-to-fit. When I copy text that is too long for the cell to the cell, the format changes to wrap text. Can I use vb to stop this from happening?

 

[Sprucy]

Hey ricksimm,

Copy
Paste Special > Values

Seems to work...

Cheers,
Sprucy