R ricksimm Board Regular Joined Apr 28, 2005 Messages 188 Dec 3, 2005 #1 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?
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?
S Sprucy Board Regular Joined Oct 31, 2005 Messages 92 Dec 3, 2005 #2 Hey ricksimm, Copy Paste Special > Values Seems to work... Cheers, Sprucy